Query Metrics
12
Database Queries
12
Different statements
50.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
| 2 | 0.11 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
]
|
| 3 | 0.43 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.36 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 | 8.12 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.maker_prices AS maker_prices_10, t0.option_area AS option_area_11, t0.option_item_area AS option_item_area_12, t0.recommend_point AS recommend_point_13, t0.sales_infomation AS sales_infomation_14, t0.list_spec AS list_spec_15, t0.maker_url AS maker_url_16, t0.creator_id AS creator_id_17, t0.product_status_id AS product_status_id_18, t0.maker_id AS maker_id_19, 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.33 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 | 7.46 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 | 9.57 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 | 23.13 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_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d0_.maker_id AS maker_id_19 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:
[ 8694 8693 8692 8691 8690 8689 8688 8687 8686 8685 8684 8683 8682 8681 8680 8679 8678 8677 8676 8675 8674 8673 8672 8671 8670 8669 8668 8667 8666 8665 8664 8663 8662 8661 8660 8659 8658 8657 8656 8655 8654 8653 8652 8651 8650 8649 8648 8647 8646 8645 8644 8643 8642 8641 8640 8639 8638 8637 8636 8635 8634 8633 8632 8631 8630 8629 8628 8627 8626 8625 8624 8623 8622 8621 8620 8619 8618 8617 8616 8615 8614 8613 8612 8611 8610 8609 8608 8607 8606 8605 8604 8603 8602 8601 8600 8599 8598 8597 8596 8595 8594 8593 8592 8591 8590 8589 8588 8587 8586 8585 8584 8583 8582 8581 8580 8579 8578 8577 8576 8575 8574 8573 8572 8571 8570 8569 8568 8567 8566 8565 8564 8563 8562 8561 8560 8559 8558 8557 8556 8555 8554 8553 8552 8551 8550 8549 8548 8547 8546 8545 8544 8543 8542 8541 8540 8539 8538 8537 8536 8535 8534 8533 8532 8531 8530 8529 8528 8527 8526 8525 8524 8523 8522 8521 8520 8519 8518 8517 8516 8515 8514 8513 8512 8511 8510 8509 8508 8507 8506 8505 8504 8503 8502 8501 8500 8499 8498 8497 8496 8495 8494 8493 8492 8491 8490 8489 8488 8487 8486 8485 8484 8483 8482 8481 8480 8479 8478 8477 8476 8475 8474 8473 8472 8471 8470 8469 8468 8467 8466 8465 8464 8463 8462 8461 8460 8459 8458 8457 8456 8455 8454 8453 8452 8451 8450 8449 8448 8447 8446 8445 8444 8443 8442 8441 8440 8439 8438 8437 8436 8435 8434 8433 8432 8431 8430 8429 8428 8427 8426 8425 8424 8423 8422 8421 8420 8419 8418 8417 8416 8415 8414 8413 8412 8411 8410 8409 8408 8407 8406 8405 8404 8403 8402 8401 8400 8399 8398 8397 8396 8395 8394 8393 8392 8391 8390 8389 8388 8387 8386 8385 8384 8383 8382 8381 8380 8379 8378 8377 8376 8375 8374 8373 8372 8371 8370 8369 8368 8367 8366 8365 8364 8363 8362 8361 8360 8359 8358 8357 8356 8355 8354 8353 8352 8351 8350 8349 8348 8347 8346 8345 8344 8343 8342 8341 8340 8339 8338 8337 8336 8335 8334 8333 8332 8331 8330 8329 8328 8327 8326 8325 8324 8323 8322 8321 8320 8319 8318 8317 8316 8315 8314 8313 8312 8311 8310 8309 8308 8307 8306 8305 8304 8303 8302 8301 8300 8299 8298 8297 8296 8295 8294 8293 8292 8291 8290 8289 8288 8287 8286 8285 8284 8283 8282 8281 8280 8279 8278 8277 8276 8275 8274 8273 8272 8271 8270 8269 8268 8267 8266 8265 8264 8263 8262 8261 8260 8259 8258 8257 8256 8255 8254 8253 8252 8251 8250 8249 8248 8247 8246 8245 8244 8243 8242 8241 8240 8239 8238 8237 8236 8235 8234 8233 8232 8231 8230 8229 8228 8227 8226 8225 8224 8223 8222 8221 8220 8219 8218 8217 8216 8215 8214 8213 8212 8211 8210 8209 8208 8207 8206 8205 8204 8203 8202 8201 8200 8199 8198 8197 8196 8195 8194 8193 8192 8191 8190 8189 8188 8187 8186 8185 8184 8183 8182 8181 8180 8179 8178 8177 8176 8175 8174 8173 8172 8171 8170 8169 8168 8167 8166 8165 8164 8163 8162 8161 8160 8159 8158 8157 8156 8155 8154 8153 8152 8151 8150 8149 8148 8147 8146 8145 8144 8143 8142 8141 8140 8139 8138 8137 8136 8135 8134 8133 8132 8131 8130 8129 8128 8127 8126 8125 8124 8123 8122 8121 8120 8119 8118 8117 8009 8008 8007 8006 8005 8004 8003 8002 8001 8000 7991 7990 7989 7988 7987 7986 7985 7984 7779 7778 7777 7776 7775 7774 7773 7772 7771 7770 7769 7768 7540 7539 7538 7537 7536 7535 7534 7533 7532 7531 7530 7529 7528 7527 7526 7525 7524 7523 7522 7521 7520 7519 7518 7517 7516 7515 7514 7513 7512 7511 7510 7509 7508 7507 7506 7505 7504 7503 7502 7501 7500 7499 7498 7497 7496 7495 7494 7493 7492 7491 7490 7489 7488 7487 7486 7485 7484 7483 7482 7481 7480 7479 7478 7477 7476 7475 7474 7473 7472 7471 7470 7469 7468 7467 7466 7465 7464 7463 7462 7461 7460 7459 7458 7457 7456 7455 7454 7453 7452 7451 7450 7449 7448 7447 7446 7445 7444 7443 7442 7441 7440 7439 7438 7437 7436 7435 7434 7433 7432 7431 7430 7429 7428 7427 7426 7425 7424 7423 7422 7421 7420 7419 7418 7417 7416 7415 7414 7413 7412 7411 7410 7409 7408 7407 7406 7405 7404 7403 7402 7401 7400 7399 7398 7397 7396 7395 7394 7393 7392 7391 7390 7389 7388 7387 7386 7385 7384 7383 7382 7381 7380 7379 7378 7377 7376 7375 7374 7373 7372 7371 7370 7369 7368 7367 7366 7365 7364 7363 7362 7361 7360 7359 7358 7357 7356 7355 7354 7353 7352 7351 7350 7349 7348 7347 7346 7345 7344 7343 7342 7341 7340 7339 7338 7337 7336 7335 7334 7333 7332 7331 7330 7329 7328 7327 7326 7325 7324 7323 7322 7321 7320 7319 7318 7317 7316 7315 7314 7313 7312 7311 7310 7309 7308 7307 7306 7305 7304 7303 7302 7301 7300 7299 7298 7297 7296 7295 7294 7293 7292 7291 7290 7289 7288 7287 7286 7285 7284 7283 7282 7281 7280 7279 7278 7277 7276 7275 7274 7273 7272 7271 7270 7269 7268 7267 7266 7265 7264 7263 7262 7261 7260 7259 7258 7257 7256 7255 7254 7253 7252 7251 7250 7249 7248 7247 7246 7245 7244 7243 7242 7241 7240 7239 7238 7237 7236 7235 7234 7233 7232 7231 7230 7229 7228 7227 7226 7225 7223 7222 7221 7219 7218 7217 7216 7215 7214 7212 7211 7210 7209 7208 7207 7206 7205 7204 7203 7202 7201 7200 7198 7197 7196 7194 7193 7192 7191 7190 7189 7188 7187 7186 7185 7184 7183 7182 7181 7180 7179 7178 7177 7176 7175 7174 7173 7172 7171 7170 7169 7168 7167 7166 7165 7164 7163 7162 7161 7160 7159 7158 7157 7156 7155 7154 7153 7152 7151 7150 7149 7148 7147 7146 7145 7144 ] |
| 12 | 0.42 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\ProductClass | No errors. |
| Eccube\Entity\Cart | No errors. |
| Eccube\Entity\Order | No errors. |
| Plugin\ProductField\Entity\ProductFieldContent | No errors. |
| Eccube\Entity\Product | No errors. |
| Plugin\ProductField\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\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. |
| Plugin\Maker42\Entity\Maker | No errors. |
| Eccube\Entity\ProductCategory | No errors. |
| Eccube\Entity\ProductImage | No errors. |
| Eccube\Entity\ProductTag | No errors. |
| Eccube\Entity\CustomerFavoriteProduct | No errors. |
| Eccube\Entity\News | No errors. |