Query Metrics
12
Database Queries
12
Different statements
41.00 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.65 ms (52.79%) |
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_.comment1 AS comment1_9, d0_.linkurl AS linkurl_10, d0_.bookcart AS bookcart_11, d0_.viewsw AS viewsw_12, d0_.recommendno AS recommendno_13, d0_.teikaref AS teikaref_14, d0_.orderdate AS orderdate_15, d0_.enddate AS enddate_16, d0_.hatsubaibi AS hatsubaibi_17, d0_.entrydate AS entrydate_18, d0_.jissize AS jissize_19, d0_.isbn AS isbn_20, d0_.amazon AS amazon_21, d0_.importfl AS importfl_22, d0_.old_create_date AS old_create_date_23, d0_.old_update_date AS old_update_date_24, d0_.free_description_about_quantity AS free_description_about_quantity_25, d0_.free_description_about_selling_price AS free_description_about_selling_price_26, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_27, d0_.discriminator_type AS discriminator_type_28, d0_.creator_id AS creator_id_29, d0_.product_status_id AS product_status_id_30 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:
[ 12543 12542 12541 12540 12539 12538 12537 12536 12535 12534 12533 12532 12531 12530 12529 12528 12527 12526 12525 12524 12523 12522 12521 12520 12519 12518 12517 12516 12515 12514 12513 12512 12511 12510 12509 12508 12507 12506 12505 12504 12503 12502 12501 12500 12499 12498 12497 12496 12495 12494 12493 12492 12491 12490 12489 12488 12487 12486 12485 12484 12483 12482 12481 12480 12479 12478 12477 12476 12475 12474 12473 12472 12471 12470 12469 12468 12467 12466 12465 12464 12463 12462 12461 12460 12459 12458 12457 12456 12455 12454 12453 12452 12451 12450 12449 12448 12447 12446 12445 12444 12443 12442 12441 12440 12439 12438 12437 12436 12435 12434 12433 12432 12431 12430 12429 12428 12427 12426 12425 12424 12423 12422 12421 12420 12419 12418 12417 12416 12415 12414 12413 12412 12411 12410 12409 12408 12407 12406 12405 12404 12403 12402 12401 12400 12399 12398 12397 12396 12395 12394 12393 12392 12391 12390 12389 12388 12387 12386 12385 12384 12383 12382 12381 12380 12379 12378 12377 12376 12375 12374 12373 12372 12371 12370 12369 12368 12367 12366 12365 12364 12363 12362 12361 12360 12359 12358 12357 12356 12355 12354 12353 12352 12351 12350 12349 12348 12347 12346 12345 12344 12343 12342 12341 12340 12339 12338 12337 12336 12335 12334 12333 12332 12331 12330 12329 12328 12327 12326 12325 12324 12323 12322 12321 12320 12319 12318 12317 12316 12315 12314 12313 12312 12311 12310 12309 12308 12307 12306 12305 12304 12303 12302 12301 12300 12299 12298 12297 12296 12295 12294 12293 12292 12291 12290 12289 12288 12287 12286 12285 12284 12283 12282 12281 12280 12279 12278 12277 12276 12275 12274 12273 12272 12271 12270 12269 12268 12267 12266 12265 12264 12263 12262 12261 12260 12259 12258 12257 12256 12255 12254 12253 12252 12251 12250 12249 12248 12247 12246 12245 12244 12243 12242 12241 12240 12239 12238 12237 12236 12235 12234 12233 12232 12231 12230 12229 12228 12227 12226 12225 12224 12223 12222 12221 12220 12219 12218 12217 12216 12215 12214 12213 12212 12211 12210 12209 12208 12207 12206 12205 12204 12203 12202 12201 12200 12199 12198 12197 12196 12195 12194 12193 12192 12191 12190 12189 12188 12187 12186 12185 12184 12183 12182 12181 12180 12179 12178 12177 12176 12175 12174 12173 12172 12171 12170 12169 12168 12167 12166 12165 12164 12163 12162 12161 12160 12159 12158 12157 12156 12155 12154 12153 12152 12151 12150 12149 12148 12147 12146 12145 12144 12143 12142 12141 12140 12139 12138 12137 12136 12135 12134 12133 12132 12131 12130 12129 12128 12127 12126 12125 12124 12123 12122 12121 12120 12119 12118 12117 12116 12115 12114 12113 12112 12111 12110 12109 12108 12107 12106 12105 12104 12103 12102 12101 12100 12099 12098 12097 12096 12095 12094 12093 12092 12091 12090 12089 12088 12087 12086 12085 12084 12083 12082 12081 12080 12079 12078 12077 12076 12075 12074 12073 12072 12071 12070 12069 12068 12067 12066 12065 12064 12063 12062 12061 12060 12059 12058 12057 12056 12055 12054 12053 12052 12051 12050 12049 12048 12047 12046 12045 12044 12043 12042 12041 12040 12039 12038 12037 12036 12035 12034 12033 12032 12031 12030 12029 12028 12027 12026 12025 12024 12023 12022 12021 12020 12019 12018 12017 12016 12015 12014 12013 12012 12011 12010 12009 12008 12007 12006 12005 12004 12003 12002 12001 12000 11999 11998 11997 11996 11995 11994 11993 11992 11991 11990 11989 11988 11987 11986 11985 11984 11983 11982 11981 11980 11979 11978 11977 11976 11975 11974 11973 11972 11971 11970 11969 11968 11967 11966 11965 11964 11963 11962 11961 11960 11959 11958 11957 11956 11955 11954 11953 11952 11951 11950 11949 11948 11947 11946 11945 11944 11943 11942 11941 11940 11939 11938 11937 11936 11935 11934 11933 11932 11931 11930 11929 11928 11927 11926 11925 11924 11923 11922 11921 11920 11919 11918 11917 11916 11915 11914 11913 11912 11911 11910 11909 11908 11907 11906 11905 11904 11903 11902 11901 11900 11899 11898 11897 11896 11895 11894 11893 11892 11891 11890 11889 11888 11887 11886 11885 11884 11883 11882 11881 11880 11879 11878 11877 11876 11875 11874 11873 11872 11871 11870 11869 11868 11867 11866 11865 11864 11863 11862 11861 11860 11859 11858 11857 11856 11855 11854 11853 11852 11851 11850 11849 11848 11847 11846 11845 11844 11843 11842 11841 11840 11839 11838 11837 11836 11835 11834 11833 11832 11831 11830 11829 11828 11827 11826 11825 11824 11823 11822 11821 11820 11819 11818 11817 11816 11815 11814 11813 11812 11811 11810 11809 11808 11807 11806 11805 11804 11803 11802 11801 11800 11799 11798 11797 11796 11795 11794 11793 11792 11791 11790 11789 11788 11787 11786 11785 11784 11783 11782 11781 11780 11779 11778 11777 11776 11775 11774 11773 11772 11771 11770 11769 11768 11767 11766 11765 11764 11763 11762 11761 11760 11759 11758 11757 11756 11755 11754 11753 11752 11751 11750 11749 11748 11747 11746 11745 11744 11743 11742 11741 11740 11739 11738 11737 11736 11735 11734 11733 11732 11731 11730 11729 11728 11727 11726 11725 11724 11723 11722 11721 11720 11719 11718 11717 11716 11715 11714 11713 11712 11711 11710 11709 11708 11707 11706 11705 11704 11703 11702 11701 11700 11699 11698 11697 11696 11695 11694 11693 11692 11691 11690 11689 11688 11687 11686 11685 11684 11683 11682 11681 11680 11679 11677 11676 11675 11674 11673 11672 11671 11670 11669 11668 11667 11666 11665 11664 11663 11662 11661 11660 11659 11658 11657 11656 11655 11654 11653 11652 11651 11650 11649 11648 11647 11646 11645 11644 11643 11642 11641 11640 11639 11638 11637 11636 11635 11634 11633 11632 11631 11630 11629 11628 11627 11626 11625 11624 11623 11622 11621 11620 11619 11618 11617 11616 11615 11614 11613 11612 11611 11610 11609 11608 11607 11606 11605 11604 11603 11602 11601 11600 11599 11598 11597 11596 11595 11594 11593 11592 11591 11590 11589 11588 11587 11586 11585 11584 11583 11582 11581 11580 11579 11578 11577 11576 11575 11574 11573 11572 11571 11570 11569 11568 11567 11566 11565 11564 11563 11562 11561 11560 11559 11558 11557 11556 11555 11554 11553 11552 11551 11550 11549 11548 11547 11546 11545 11544 11543 ] |
|
5.50 ms (13.42%) |
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:
[] |
|
4.47 ms (10.90%) |
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.comment1 AS comment1_10, t0.linkurl AS linkurl_11, t0.bookcart AS bookcart_12, t0.viewsw AS viewsw_13, t0.recommendno AS recommendno_14, t0.teikaref AS teikaref_15, t0.orderdate AS orderdate_16, t0.enddate AS enddate_17, t0.hatsubaibi AS hatsubaibi_18, t0.entrydate AS entrydate_19, t0.jissize AS jissize_20, t0.isbn AS isbn_21, t0.amazon AS amazon_22, t0.importfl AS importfl_23, t0.old_create_date AS old_create_date_24, t0.old_update_date AS old_update_date_25, t0.free_description_about_quantity AS free_description_about_quantity_26, t0.free_description_about_selling_price AS free_description_about_selling_price_27, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_28, t0.creator_id AS creator_id_29, t0.product_status_id AS product_status_id_30, 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
]
|
|
4.30 ms (10.49%) |
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:
[] |
|
2.47 ms (6.02%) |
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.81 ms (1.96%) |
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"
]
|
|
0.77 ms (1.89%) |
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.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.discriminator_type IN ('category') ORDER BY t0.update_date DESC LIMIT 1
Parameters:
[] |
|
0.44 ms (1.08%) |
1 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
|
0.26 ms (0.64%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.18 ms (0.44%) |
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.10 ms (0.26%) |
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
]
|
|
0.05 ms (0.11%) |
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. |
| Eccube\Entity\BaseInfo | 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\AbstractMasterEntity | No errors. |
| Eccube\Entity\Master\DeviceType | No errors. |
| Eccube\Entity\AuthorityRole | No errors. |
| Eccube\Entity\Layout | No errors. |
| Eccube\Entity\Order | No errors. |
| Eccube\Entity\Customer | No errors. |
| Eccube\Entity\Master\Country | No errors. |
| Eccube\Entity\Master\Pref | No errors. |
| Eccube\Entity\Category | No errors. |
| Eccube\Entity\Master\ProductListOrderBy | No errors. |
| Plugin\EccubePaymentLite42\Entity\Config | No errors. |
| Eccube\Entity\Member | No errors. |
| Eccube\Entity\Master\ProductStatus | No errors. |
| Eccube\Entity\ProductCategory | No errors. |
| Eccube\Entity\ProductClass |
|
| Eccube\Entity\ProductImage | No errors. |
| Eccube\Entity\ProductTag | No errors. |
| Eccube\Entity\CustomerFavoriteProduct | No errors. |
| Plugin\MailMagazine42\Entity\MailMagazineSendHistory | No errors. |