Query Metrics
12
Database Queries
12
Different statements
138.83 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.11 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
| 2 | 0.14 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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.site_kit_site_id AS site_kit_site_id_34, t0.site_kit_site_secret AS site_kit_site_secret_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
]
|
| 3 | 0.57 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"
]
|
| 4 | 0.07 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
| 5 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 0.50 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:
[] |
| 7 | 45.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.model_number AS model_number_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
]
|
| 8 | 0.37 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
]
|
| 9 | 21.77 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:
[] |
| 10 | 58.07 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:
[] |
| 11 | 10.92 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_.model_number AS model_number_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:
[ 45301 45300 45299 45298 45297 45291 45290 45289 45288 45287 45286 45285 45284 45283 45282 45281 45280 45279 45278 45277 45276 45275 45274 45273 45272 45271 45270 45269 45268 45267 45266 45265 45264 45263 45262 45261 45229 45228 45227 45226 45225 45224 45223 45222 45221 45220 45219 45218 45217 45216 45215 45214 45213 45212 45211 45210 45209 45208 45207 45206 45197 45196 45195 45194 45193 45192 45191 45190 45189 45188 45187 45186 45185 45184 45183 45182 45181 45180 45179 45178 45177 45176 45175 45170 45169 45168 45167 45166 45165 45152 45151 45150 45149 45148 45147 45146 45145 45144 45143 45142 45141 45140 45139 45138 45137 45136 45135 45134 45133 45132 45131 45130 45129 45128 45127 45126 45125 45124 45123 45122 45121 45120 45119 45118 45117 45116 45115 45114 45113 45112 45111 45110 45109 45108 45107 45106 45105 45104 45103 45102 45101 45100 45099 45098 45097 45044 45043 45042 45041 45040 45039 45038 45037 45036 45035 45034 45033 45032 45031 45030 45029 45028 45027 45026 45025 45024 45023 45022 45021 45020 45019 45018 45017 45016 45015 45014 45013 45012 45011 45010 45009 45008 45007 45006 45005 45004 45003 45002 45001 45000 44999 44998 44997 44996 44995 44994 44993 44992 44990 44989 44988 44986 44985 44984 44983 44982 44981 44980 44979 44978 44977 44976 44975 44974 44973 44972 44935 44925 44923 44922 44912 44911 44910 44908 44906 44905 44904 44903 44902 44901 44900 44899 44898 44897 44896 44895 44894 44893 44892 44861 44860 44859 44858 44857 44856 44855 44854 44853 44852 44851 44850 44849 44847 44846 44845 44844 44842 44841 44840 44839 44838 44837 44836 44835 44834 44833 44832 44831 44830 44829 44828 44827 44826 44825 44824 44823 44822 44821 44820 44819 44818 44817 44816 44815 44814 44813 44812 44811 44810 44809 44808 44807 44806 44805 44804 44803 44713 44712 44711 44710 44709 44708 44707 44706 44705 44704 44703 44702 44701 44700 44699 44698 44697 44696 44695 44694 44693 44692 44691 44690 44689 44688 44687 44686 44685 44684 44683 44682 44681 44680 44679 44678 44677 44676 44675 44674 44673 44672 44671 44670 44669 44668 44667 44666 44665 44664 44663 44662 44661 44660 44659 44658 44657 44656 44655 44654 44653 44652 44651 44650 44649 44648 44647 44646 44645 44644 44643 44642 44641 44640 44639 44638 44637 44636 44635 44634 44633 44632 44631 44630 44629 44628 44627 44626 44625 44624 44623 44622 44621 44620 44619 44618 44617 44616 44615 44614 44613 44612 44611 44610 44609 44608 44607 44606 44605 44604 44603 44602 44601 44600 44599 44598 44597 44596 44595 44594 44593 44592 44591 44590 44589 44588 44587 44586 44585 44584 44583 44582 44581 44580 44579 44578 44577 44576 44575 44574 44573 44572 44571 44570 44569 44568 44567 44566 44565 44564 44563 44562 44561 44560 44559 44558 44557 44556 44555 44554 44553 44552 44551 44550 44549 44548 44547 44546 44545 44544 44543 44542 44541 44540 44539 44538 44537 44536 44535 44534 44533 44532 44531 44530 44529 44528 44527 44526 44525 44524 44523 44522 44521 44520 44519 44515 44514 44513 44512 44511 44510 44509 44508 44507 44506 44505 44504 44503 44502 44501 44500 44499 44498 44497 44496 44495 44494 44493 44492 44487 44486 44485 44484 44483 44482 44481 44480 44479 44478 44477 44476 44475 44474 44473 44472 44471 44470 44469 44468 44467 44466 44465 44460 44459 44458 44453 44452 44451 44450 44449 44448 44447 44446 44445 44444 44443 44442 44440 44439 44438 44437 44435 44434 44433 44432 44428 44427 44426 44425 44424 44419 44418 44417 44416 44415 44414 44413 44412 44411 44410 44409 44408 44407 44406 44405 44404 44403 44402 44401 44400 44399 44398 44397 44396 44395 44394 44393 44392 44391 44390 44389 44388 44387 44386 44385 44384 44383 44382 44381 44380 44379 44378 44377 44376 44375 44374 44373 44372 44371 44370 44369 44368 44367 44366 44365 44364 44363 44362 44361 44360 44359 44358 44357 44356 44355 44354 44353 44352 44351 44350 44349 44348 44347 44346 44345 44344 44343 44342 44341 44340 44339 44320 44319 44318 44317 44316 44315 44314 44313 44312 44311 44310 44309 44308 44307 44306 44305 44304 44303 44302 44301 44300 44299 44298 44297 44296 44295 44294 44293 44292 44291 44290 44289 44288 44287 44286 44285 44284 44283 44282 44281 44280 44279 44278 44277 44276 44275 44274 44273 44272 44271 44270 44269 44268 44267 44266 44265 44264 44263 44262 44261 44260 44259 44258 44257 44256 44255 44254 44217 44216 44215 44214 44213 44212 44211 44210 44209 44208 44207 44206 44205 44204 44203 44202 44201 44200 44199 44198 44197 44196 44195 44194 44185 44184 44183 44182 44181 44180 44179 44178 44177 44176 44175 44174 44173 44172 44171 44170 44169 44168 44167 44166 44165 44164 44163 44162 44161 44160 44159 44158 44157 44156 44155 44154 44153 44152 44151 44150 44149 44148 44147 44146 44145 44144 44143 44142 44141 44140 44139 44138 44137 44136 44135 44134 44133 44132 44131 44130 44129 44128 44127 44126 44125 44124 44123 44122 44121 44120 44119 44118 44117 44116 44115 44114 44113 44112 44111 44110 44109 44108 44107 44106 44105 44104 44103 44102 44101 44100 44099 44098 44097 44096 44095 44094 44093 44092 44091 44090 44089 44088 44087 44086 44085 44084 44083 44082 44081 44080 44079 44078 44077 44076 44075 44074 44073 44072 44071 44070 44069 44068 44067 44066 44065 44064 44063 44062 44061 44060 44059 44058 44057 44056 44055 44054 44053 44052 44051 44050 44049 44048 44047 44046 44045 44044 44043 44042 44041 44040 44039 44038 44037 44036 44035 44034 44033 44032 44031 44030 44029 44028 44027 44026 44025 44024 44023 44022 44021 44020 44019 44018 44017 44016 44015 44014 44013 44012 44011 44010 44009 44008 44007 44006 44005 44004 44003 44002 44001 44000 43999 43998 43997 43996 43995 43994 43993 43992 43991 43990 43989 43988 43987 43986 43985 43984 43983 43982 43981 43980 43979 43978 43977 43976 43975 43974 43973 43972 43971 43970 43969 43968 43967 43966 43965 43964 43963 43962 43961 43960 43959 43958 43957 43956 43955 43954 43953 43952 43951 43950 43949 43948 43947 43946 43945 43944 43943 43942 43941 43940 43939 43938 43937 43936 43935 43934 43933 43932 43931 43930 43929 43928 43927 43926 43925 43924 ] |
| 12 | 0.67 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.description AS description_7, t0.parent_category_id AS parent_category_id_8, t0.creator_id AS creator_id_9, 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. |
| 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 |
|
| 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. |