Query Metrics
13
Database Queries
13
Different statements
26.56 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.38 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
| 2 | 0.61 ms |
SELECT t0.id AS id_1, t0.site_key AS site_key_2, t0.secret_key AS secret_key_3, t0.enable_admin_login AS enable_admin_login_4, t0.enable_front_login AS enable_front_login_5, t0.enable_contact AS enable_contact_6, t0.enable_entry AS enable_entry_7, t0.enable_forgot AS enable_forgot_8, t0.enable_shopping AS enable_shopping_9, t0.enable_non_member AS enable_non_member_10, t0.hide_badge AS hide_badge_11, t0.threshold AS threshold_12, t0.threshold_admin_login AS threshold_admin_login_13, t0.log_mode AS log_mode_14, t0.request_method AS request_method_15 FROM plg_always_re_captcha_config t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0.88 ms |
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
]
|
| 4 | 1.04 ms |
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"
]
|
| 5 | 0.56 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
| 6 | 0.95 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 3.49 ms |
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:
[] |
| 8 | 3.58 ms |
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.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
]
|
| 9 | 2.36 ms |
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
]
|
| 10 | 1.95 ms |
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:
[] |
| 11 | 1.95 ms |
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:
[] |
| 12 | 6.10 ms |
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 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:
[ 1257 1254 1253 1252 1248 1242 1236 1235 1229 1228 1224 1222 1220 1218 1189 1188 1187 1186 1185 1184 1175 1155 1154 1151 1148 1146 1145 1143 1142 1141 1139 1138 1137 1129 1125 1124 1118 1117 1114 1113 1110 1109 1106 1104 1101 1100 1099 1097 1095 1094 1093 1092 1090 1089 1088 1087 1086 1084 1082 1081 1080 1079 1078 1077 1076 1075 1074 1073 1072 1071 1070 1066 1065 1063 1062 1061 1060 1059 1058 1057 1055 1054 1050 1046 1044 1043 1039 1037 1035 1033 1032 1031 1030 1029 1028 1027 1026 1025 1024 1023 1022 1021 1019 1015 1012 1011 1007 1006 1005 1004 1003 997 996 995 994 989 988 986 985 984 982 980 972 971 963 962 961 960 959 958 951 946 941 940 936 935 934 933 932 928 927 922 921 916 914 911 905 904 903 898 896 895 893 883 881 877 874 873 871 870 869 868 867 866 865 864 863 862 861 860 859 858 857 856 855 854 853 852 851 850 849 848 847 846 845 844 843 842 840 839 838 837 836 835 833 832 830 829 828 827 826 825 824 822 820 818 817 816 814 813 812 811 810 809 808 807 806 802 801 800 799 796 795 794 793 787 780 778 724 723 722 721 720 719 718 717 716 715 714 713 712 711 710 709 708 707 706 705 704 703 702 701 700 699 698 676 675 674 673 672 671 670 668 667 666 664 663 659 658 657 656 655 654 653 652 651 650 649 648 646 645 644 643 642 641 640 639 638 636 635 634 633 632 630 627 626 620 619 618 617 616 615 614 613 612 611 610 609 608 607 606 605 604 603 602 601 600 599 598 597 596 595 594 593 592 591 590 589 588 587 586 585 584 583 582 581 580 579 578 577 576 575 574 573 572 571 570 569 568 567 565 564 563 562 561 559 558 557 556 555 554 553 552 551 550 549 548 547 546 545 544 543 542 541 540 539 538 537 536 535 534 533 532 531 530 529 528 527 525 524 523 521 520 518 517 516 515 514 513 512 511 510 509 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 490 489 488 487 486 484 483 480 479 478 477 475 473 472 467 466 465 463 462 461 460 459 457 455 452 451 450 449 448 446 445 444 442 441 438 437 436 434 432 431 428 426 425 424 421 420 419 418 417 416 415 414 413 411 409 408 407 406 405 404 403 402 401 400 399 398 397 396 395 393 392 391 390 389 388 387 386 384 380 379 378 377 376 375 374 372 370 369 368 363 361 359 358 355 353 352 349 348 347 345 343 342 341 340 339 338 337 336 335 334 333 332 331 330 329 328 325 324 323 322 321 320 319 318 317 316 315 314 312 311 310 309 308 307 304 303 302 301 300 298 297 295 293 292 291 289 283 282 280 279 278 276 275 274 273 272 271 270 269 266 265 264 263 262 259 258 255 253 252 251 249 248 247 246 245 244 242 241 240 239 238 237 236 235 233 232 227 223 222 221 220 217 216 215 214 213 209 206 204 203 197 196 194 193 192 190 187 185 183 180 178 176 175 173 172 171 169 168 167 163 162 161 160 158 157 156 155 154 153 152 151 150 149 148 147 146 145 144 143 142 141 140 139 138 137 136 135 134 133 132 131 130 129 128 127 126 125 124 123 122 121 120 119 118 117 116 115 114 113 112 111 110 109 108 107 106 105 104 103 102 101 100 99 98 97 96 95 94 93 92 91 90 89 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 67 66 65 64 59 58 57 55 53 49 47 43 41 38 37 34 32 30 26 24 20 18 13 8 6 5 4 3 ] |
| 13 | 1.70 ms |
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:
[] |
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\AlwaysReCaptcha42\Entity\Config | 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. |
| 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. |