Query Metrics
12
Database Queries
12
Different statements
165.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
55.80 ms (33.71%) |
1 |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product')
Parameters:
[] |
|
41.69 ms (25.18%) |
1 |
SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 1000
Parameters:
[] |
|
41.48 ms (25.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.creator_id AS creator_id_10, t0.product_status_id AS product_status_id_11, t0.brand_id AS brand_id_12, t0.discriminator_type FROM dtb_product t0 WHERE t0.product_status_id = ? AND t0.discriminator_type IN ('product') ORDER BY t0.update_date DESC LIMIT 1
Parameters:
[
1
]
|
|
18.78 ms (11.35%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.discriminator_type AS discriminator_type_9, d0_.creator_id AS creator_id_10, d0_.product_status_id AS product_status_id_11, d0_.brand_id AS brand_id_12 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC
Parameters:
[ 31677 31676 31674 31672 31649 31630 31629 31628 31627 31626 31625 31624 31623 31622 31608 31606 31605 31604 31570 31568 31567 31565 31564 31557 31556 31555 31518 31517 31516 31507 31505 31504 31503 31502 31501 31500 31499 31496 31495 31494 31493 31492 31491 31490 31489 31488 31487 31486 31485 31484 31483 31482 31481 31480 31479 31478 31477 31476 31464 31463 31462 31461 31460 31459 31457 31456 31455 31454 31453 31452 31451 31450 31449 31448 31447 31446 31445 31444 31443 31442 31441 31440 31439 31438 31437 31436 31430 31413 31412 31411 31410 31409 31408 31407 31406 31405 31404 31403 31402 31401 31400 31397 31392 31391 31390 31389 31388 31383 31358 31357 31356 31355 31354 31353 31352 31351 31350 31349 31348 31347 31346 31345 31327 31326 31325 31324 31323 31322 31321 31320 31319 31318 31317 31287 31282 31281 31278 31276 31275 31274 31273 31272 31271 31270 31269 31268 31267 31266 31265 31264 31263 31262 31261 31260 31259 31258 31257 31256 31255 31254 31253 31252 31251 31250 31249 31248 31247 31246 31245 31244 31243 31242 31241 31240 31239 31238 31237 31236 31235 31227 31224 31223 31222 31221 31220 31219 31218 31214 31207 31205 31204 31203 31188 31187 31186 31185 31184 31183 31182 31181 31180 31179 31178 31176 31173 31172 31171 31165 31164 31163 31161 31160 31115 31114 31113 31112 31111 31103 31102 31101 31100 31099 31098 31097 31093 31091 31089 31056 31052 31051 31050 31049 31048 31047 31046 31045 31044 31043 31042 31041 31029 31025 31024 31023 31022 31012 31011 31010 31009 31008 31007 31006 31005 31004 31003 31002 31001 31000 30999 30998 30997 30996 30995 30994 30993 30992 30939 30938 30937 30936 30935 30934 30933 30932 30926 30925 30920 30878 30827 30826 30825 30824 30823 30822 30821 30820 30819 30818 30811 30810 30809 30806 30805 30804 30803 30802 30801 30800 30799 30798 30797 30796 30795 30794 30793 30792 30791 30790 30789 30788 30787 30786 30785 30784 30783 30782 30781 30780 30779 30778 30777 30776 30775 30774 30773 30772 30771 30770 30769 30768 30767 30766 30765 30764 30763 30762 30761 30760 30759 30758 30757 30756 30755 30754 30753 30752 30751 30750 30749 30748 30747 30746 30745 30744 30743 30742 30741 30740 30739 30738 30737 30736 30735 30734 30733 30732 30731 30730 30729 30728 30727 30726 30725 30724 30723 30722 30721 30720 30719 30718 30717 30716 30715 30714 30713 30712 30711 30710 30709 30708 30707 30706 30705 30704 30703 30702 30701 30700 30699 30698 30697 30696 30695 30694 30693 30692 30691 30690 30689 30688 30687 30686 30685 30684 30683 30682 30681 30680 30679 30678 30677 30676 30675 30674 30673 30672 30671 30670 30669 30668 30667 30666 30665 30664 30663 30662 30661 30660 30659 30658 30657 30656 30655 30654 30653 30652 30651 30650 30649 30648 30647 30646 30645 30644 30643 30642 30641 30640 30639 30638 30637 30636 30635 30634 30633 30632 30631 30630 30629 30628 30627 30626 30625 30624 30623 30622 30621 30620 30619 30618 30617 30616 30615 30614 30613 30612 30611 30610 30609 30608 30607 30606 30605 30604 30603 30602 30601 30600 30599 30598 30597 30596 30595 30594 30593 30592 30591 30590 30589 30588 30587 30586 30585 30584 30583 30582 30581 30580 30579 30578 30577 30576 30575 30574 30573 30572 30571 30570 30569 30568 30567 30566 30565 30564 30563 30562 30561 30560 30559 30558 30557 30556 30555 30554 30553 30552 30551 30550 30549 30548 30547 30546 30545 30544 30542 30541 30540 30539 30538 30537 30536 30535 30534 30533 30532 30531 30530 30529 30528 30527 30522 30521 30520 30519 30518 30517 30516 30515 30514 30513 30512 30447 30446 30445 30444 30443 30442 30441 30440 30439 30438 30437 30436 30435 30434 30433 30432 30431 30430 30429 30428 30427 30426 30425 30424 30423 30422 30421 30420 30419 30418 30417 30416 30415 30414 30413 30412 30411 30410 30409 30408 30407 30406 30405 30404 30403 30402 30401 30400 30399 30398 30397 30396 30395 30394 30393 30392 30391 30390 30335 30333 30332 30331 30330 30329 30328 30327 30326 30325 30324 30323 30322 30321 30320 30319 30318 30317 30316 30315 30314 30313 30312 30311 30310 30309 30308 30307 30306 30305 30303 30302 30301 30300 30299 30298 30297 30296 30295 30294 30293 30292 30291 30290 30289 30288 30287 30286 30285 30284 30283 30282 30281 30280 30279 30278 30277 30276 30275 30274 30273 30272 30271 30270 30269 30268 30267 30266 30265 30264 30263 30262 30261 30260 30259 30258 30257 30256 30255 30254 30253 30250 30249 30248 30247 30246 30245 30244 30243 30242 30241 30240 30238 30237 30234 30233 30232 30231 30230 30229 30228 30227 30226 30225 30224 30223 30222 30221 30220 30219 30218 30217 30216 30215 30214 30213 30212 30211 30210 30209 30208 30207 30206 30205 30204 30203 30202 30201 30200 30199 30198 30197 30196 30195 30194 30193 30192 30191 30190 30189 30188 30187 30185 30184 30183 30182 30181 30179 30178 30177 30173 30171 30170 30168 30167 30166 30165 30164 30163 30162 30161 30159 30158 30157 30156 30155 30154 30153 30152 30147 30143 30142 30141 30140 30139 30138 30136 30135 30134 30133 30132 30131 30130 30129 30128 30127 30126 30125 30124 30123 30122 30121 30120 30119 30118 30117 30116 30114 30113 30112 30110 30109 30108 30107 30106 30105 30104 30103 30102 30101 30100 30099 30098 30097 30096 30095 30094 30093 30092 30091 30090 30089 30088 30087 30086 30085 30084 30083 30082 30081 30080 30079 30078 30077 30076 30075 30074 30073 30072 30071 30070 30069 30068 30067 30066 30065 30064 30063 30062 30061 30060 30059 30058 30057 30056 30055 30054 30053 30052 30050 30048 30047 30046 30045 30044 30043 30042 30041 30040 30039 30038 30037 30036 30035 30034 30033 30032 30031 30030 30029 30028 30027 30026 30025 30024 30023 30022 30021 30020 30019 30018 30017 30016 30015 30014 30013 30012 30011 30010 30009 30008 30007 30006 30005 30004 30003 30002 30001 30000 29999 29998 29997 29996 29995 29994 29993 29992 29991 29990 29989 29988 29987 29986 29985 29984 29983 29982 29981 29980 29979 29978 29977 29976 29975 29974 29973 29972 29971 29970 29969 29968 29967 29966 29965 29964 29963 29962 29961 29960 29959 29958 29957 29956 29955 29954 29953 29952 29951 29950 29949 29948 ] |
|
1.85 ms (1.12%) |
1 |
SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d0_.discriminator_type AS discriminator_type_12, d0_.master_page_id AS master_page_id_13 FROM dtb_page d0_ WHERE ((((d0_.meta_robots NOT LIKE '%noindex%' AND d0_.meta_robots NOT LIKE '%none%') OR d0_.meta_robots IS NULL)) AND d0_.id <> 0 AND d0_.master_page_id IS NULL) AND d0_.discriminator_type IN ('page') ORDER BY d0_.update_date DESC LIMIT 1
Parameters:
[] |
|
1.41 ms (0.85%) |
1 |
SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page')
Parameters:
[
"sitemap_xml"
]
|
|
1.32 ms (0.80%) |
1 |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.ga_id AS ga_id_35, t0.country_id AS country_id_36, t0.pref_id AS pref_id_37, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
|
1.29 ms (0.78%) |
1 |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.discriminator_type IN ('category') ORDER BY t0.update_date DESC LIMIT 1
Parameters:
[] |
|
0.81 ms (0.49%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productlistorderby')
Parameters:
[
2
]
|
|
0.62 ms (0.37%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.26 ms (0.16%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.21 ms (0.13%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Eccube\Entity\AbstractEntity | No errors. |
| Eccube\Entity\BaseInfo | No errors. |
| Eccube\Entity\Master\AbstractMasterEntity | No errors. |
| Eccube\Entity\Master\Country | No errors. |
| Eccube\Entity\Master\Pref | No errors. |
| Eccube\Entity\Page | No errors. |
| Eccube\Entity\PageLayout | No errors. |
| Eccube\Entity\Layout | No errors. |
| Eccube\Entity\Master\DeviceType | No errors. |
| Eccube\Entity\Product | No errors. |
| Eccube\Entity\Member | No errors. |
| Eccube\Entity\Master\ProductStatus | No errors. |
| Customize\Entity\Brand | No errors. |
| Eccube\Entity\ProductCategory | No errors. |
| Eccube\Entity\ProductClass | No errors. |
| Eccube\Entity\ProductImage | No errors. |
| Eccube\Entity\ProductTag | No errors. |
| Eccube\Entity\CustomerFavoriteProduct | No errors. |
| Eccube\Entity\Master\ProductListOrderBy | No errors. |
| Eccube\Entity\Category | No errors. |