Query Metrics
13
Database Queries
13
Different statements
111.28 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.35 ms (29.07%) |
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.reserve_date AS reserve_date_10, t0.creator_id AS creator_id_11, t0.product_status_id AS product_status_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
]
|
|
30.54 ms (27.45%) |
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:
[] |
|
21.66 ms (19.47%) |
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:
[] |
|
16.65 ms (14.96%) |
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_.reserve_date AS reserve_date_9, d0_.discriminator_type AS discriminator_type_10, d0_.creator_id AS creator_id_11, d0_.product_status_id AS product_status_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:
[ 16105 16104 16103 16102 16101 16100 16099 16098 16097 16096 16095 16094 16093 16092 16091 16090 16089 16088 16087 16086 16085 16084 16083 16082 16081 16080 16079 16078 16077 16076 16075 16074 16073 16072 16071 16070 16069 16067 16066 16065 16064 16063 16062 16061 16060 16059 16058 16057 16056 16055 16054 16053 16052 16051 16050 16049 16048 16047 16046 16045 16044 16043 16042 16041 16040 16039 16038 16037 16036 16035 16034 16033 16032 16031 16030 16029 16028 16027 16026 16025 16024 16023 16022 16021 16020 16019 16018 16017 16016 16015 16014 16013 16012 16011 16010 16009 16008 16007 16006 16005 16004 16003 16002 16001 16000 15999 15998 15997 15996 15995 15994 15993 15992 15991 15989 15988 15987 15986 15985 15984 15983 15981 15980 15978 15977 15976 15974 15972 15971 15970 15969 15968 15967 15966 15963 15962 15961 15960 15959 15958 15957 15956 15955 15954 15953 15952 15950 15949 15948 15947 15946 15945 15944 15943 15942 15941 15940 15939 15938 15937 15936 15935 15934 15933 15932 15931 15930 15929 15928 15927 15926 15925 15924 15923 15922 15921 15920 15919 15918 15917 15916 15915 15914 15913 15912 15911 15910 15909 15908 15907 15906 15905 15904 15903 15902 15901 15900 15899 15898 15897 15896 15895 15894 15893 15892 15891 15890 15889 15888 15887 15886 15885 15884 15883 15882 15881 15880 15879 15878 15877 15876 15875 15874 15873 15872 15871 15870 15869 15868 15867 15866 15865 15864 15863 15862 15861 15860 15859 15858 15857 15856 15855 15854 15853 15852 15851 15850 15849 15848 15847 15846 15845 15844 15843 15842 15841 15840 15839 15838 15837 15836 15835 15834 15833 15832 15831 15812 15811 15810 15809 15808 15807 15806 15805 15804 15803 15802 15801 15800 15799 15798 15796 15795 15794 15793 15792 15791 15790 15789 15788 15787 15786 15785 15784 15783 15782 15781 15780 15779 15778 15777 15776 15775 15774 15773 15772 15771 15770 15769 15768 15767 15766 15765 15764 15763 15762 15761 15760 15759 15758 15757 15756 15755 15754 15753 15752 15751 15750 15749 15748 15736 15732 15730 15726 15722 15719 15718 15717 15715 15714 15713 15708 15707 15706 15704 15702 15701 15700 15699 15691 15689 15688 15687 15680 15676 15667 15665 15658 15657 15656 15653 15645 15642 15641 15640 15639 15638 15637 15636 15635 15634 15633 15632 15631 15630 15629 15628 15627 15626 15625 15624 15623 15622 15621 15620 15619 15618 15617 15616 15615 15614 15613 15612 15611 15610 15609 15607 15606 15605 15604 15603 15602 15601 15600 15599 15598 15597 15596 15595 15594 15593 15592 15591 15590 15589 15588 15549 15548 15547 15546 15545 15544 15543 15542 15541 15540 15539 15538 15537 15520 15517 15515 15511 15510 15502 15499 15497 15496 15491 15490 15489 15488 15485 15482 15481 15480 15479 15462 15460 15459 15453 15437 15403 15401 15400 15399 15398 15397 15396 15395 15394 15393 15392 15391 15390 15389 15388 15387 15386 15385 15384 15383 15381 15380 15379 15378 15377 15376 15375 15374 15373 15372 15371 15370 15369 15368 15367 15366 15365 15364 15363 15362 15361 15360 15359 15358 15357 15356 15355 15354 15353 15352 15351 15350 15349 15348 15347 15346 15345 15344 15343 15342 15341 15340 15339 15338 15337 15336 15335 15334 15327 15326 15325 15324 15323 15322 15321 15320 15319 15318 15317 15316 15314 15313 15312 15311 15310 15309 15308 15307 15306 15305 15303 15302 15301 15299 15298 15297 15296 15295 15294 15293 15292 15291 15290 15289 15288 15287 15286 15285 15284 15283 15282 15281 15280 15279 15278 15277 15276 15275 15274 15273 15272 15271 15270 15269 15268 15267 15264 15263 15262 15261 15260 15259 15258 15257 15256 15255 15254 15253 15252 15251 15250 15249 15248 15247 15246 15245 15244 15243 15242 15241 15240 15239 15238 15237 15236 15235 15234 15233 15232 15231 15230 15229 15228 15227 15226 15225 15224 15223 15222 15221 15220 15219 15218 15217 15216 15215 15214 15213 15212 15211 15210 15209 15208 15207 15206 15205 15204 15203 15202 15201 15200 15198 15197 15196 15195 15194 15193 15192 15191 15190 15189 15188 15187 15186 15185 15184 15183 15182 15181 15177 15176 15175 15174 15173 15172 15171 15170 15169 15168 15167 15166 15165 15164 15163 15162 15161 15160 15159 15158 15157 15156 15155 15154 15153 15152 15151 15150 15149 15148 15147 15146 15145 15144 15143 15142 15141 15140 15139 15138 15137 15136 15135 15134 15133 15132 15131 15130 15129 15128 15127 15126 15125 15124 15123 15122 15121 15120 15119 15118 15117 15116 15115 15114 15113 15112 15111 15110 15109 15108 15107 15106 15105 15104 15103 15102 15101 15100 15099 15098 15097 15096 15095 15094 15093 15092 15091 15090 15089 15088 15087 15086 15085 15084 15083 15082 15081 15080 15079 15078 15077 15076 15075 15074 15073 15072 15071 15070 15069 15068 15067 15066 15065 15064 15063 15062 15061 15060 15059 15058 15057 15056 15055 15054 15053 15052 15051 15050 15049 15048 15047 15046 15045 15044 15043 15042 15041 15040 15039 15038 15037 15036 15035 15033 15032 15031 15030 15029 15028 15027 15026 15025 15024 15023 15022 15021 15020 15019 15018 15017 15016 15015 15014 15013 15012 15011 15010 15009 15007 15006 15005 15004 15003 15002 15001 15000 14999 14998 14997 14996 14995 14994 14993 14992 14991 14990 14989 14988 14987 14986 14985 14984 14983 14982 14981 14980 14979 14978 14977 14976 14975 14974 14973 14972 14971 14970 14968 14967 14966 14965 14964 14963 14962 14961 14960 14959 14957 14956 14955 14954 14953 14952 14951 14950 14949 14948 14947 14946 14945 14944 14943 14942 14941 14940 14939 14938 14937 14935 14934 14933 14932 14931 14930 14929 14927 14926 14925 14924 14923 14922 14921 14920 14919 14915 14914 14913 14912 14911 14910 14909 14908 14907 14906 14905 14904 14903 14902 14901 14900 14899 14898 14897 14896 14895 14894 14889 14888 14887 14886 14885 14884 14883 14882 14881 14880 14879 14878 14877 14876 14875 14874 14873 14872 14871 14870 14869 14868 14867 14866 14865 14864 14863 14862 14861 14860 14859 14858 14857 14856 14855 14854 14853 14852 14851 14850 14849 14848 14847 14846 14845 14844 14843 14842 14841 14840 14839 14838 14837 14836 14835 14834 14833 14832 14831 14830 14829 14828 14827 14826 ] |
|
1.77 ms (1.59%) |
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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
|
1.67 ms (1.50%) |
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
]
|
|
1.67 ms (1.50%) |
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.46 ms (1.32%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
1.04 ms (0.94%) |
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.95 ms (0.86%) |
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:
[] |
|
0.63 ms (0.57%) |
1 |
SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0
Parameters:
[] |
|
0.47 ms (0.42%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.40 ms (0.36%) |
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\Product | No errors. |
| Plugin\OrderStatusEx\Entity\OrderStatusEx | 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. |
| Plugin\PointExDx\Entity\EntryPoint | No errors. |
| Eccube\Entity\Page | No errors. |
| Eccube\Entity\PageLayout | No errors. |
| Eccube\Entity\Block | No errors. |
| Eccube\Entity\BlockPosition | No errors. |
| Eccube\Entity\Master\DeviceType | No errors. |
| Eccube\Entity\AuthorityRole | No errors. |
| Eccube\Entity\Layout | No errors. |
| Eccube\Entity\Order |
|
| Eccube\Entity\Customer | No errors. |
| Eccube\Entity\Category | No errors. |
| Eccube\Entity\Master\ProductListOrderBy | No errors. |
| Eccube\Entity\Member | No errors. |
| Eccube\Entity\Master\ProductStatus | 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. |
| Plugin\MailMagazine42\Entity\MailMagazineSendHistory | No errors. |
| Plugin\Api42\Entity\WebHook | No errors. |