Query Metrics
28
Database Queries
11
Different statements
38.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.25 ms (57.69%) |
1 |
SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.is_display_site = ?
Parameters:
[ 2786 2788 3023 3032 3033 3037 3038 3042 3043 3047 3048 3050 3053 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 4376 5707 5712 5713 5714 5715 5821 5829 5831 5832 5834 5992 6482 6483 6827 6828 6829 8235 8237 8240 8242 9030 9032 9033 9034 9035 9201 9203 9238 9239 9651 9835 10401 10404 10407 25637 25851 25852 25854 25855 25856 25857 25860 25861 25863 25968 25969 25971 25972 25973 25975 25976 25977 28622 28624 28689 28691 28692 28693 28694 28695 28696 28697 28698 28699 28700 28701 28702 29215 29278 29279 29280 29434 29435 29436 29437 29438 29439 29930 29931 30789 30790 30791 30792 30793 30794 30799 31669 33390 33404 53364 54544 55013 55023 55238 56040 59346 59347 59348 59349 59351 59352 59353 60002 61651 61652 63545 64157 64158 64159 64160 64161 69391 69393 69394 69396 69679 69680 69681 70012 70015 70018 70019 70020 70021 70022 70706 70707 70879 70881 70887 70888 70889 70891 70893 70894 70895 70899 70900 70901 72393 72562 78749 78751 78753 79401 80391 80392 80393 80394 80395 80396 80399 80400 80406 80407 80408 80409 80410 80424 85316 85317 85318 85319 85320 85321 85322 85323 85324 85325 85342 85343 85344 87514 87515 93631 93643 93726 96760 96761 96762 96763 96764 96765 96766 96771 97221 101460 101463 106148 106364 106365 122421 122422 122960 128553 130905 132033 133882 143988 143990 148554 148556 148557 149250 163610 163611 163615 163617 163930 163931 163932 163933 163934 163961 165467 165468 165469 165470 165471 165472 182994 183762 193377 195406 195815 198618 199217 199218 199219 199322 199323 201528 203437 216709 216710 221517 221518 221519 221520 221521 221522 221523 221524 221525 221526 239639 239640 240309 240312 241238 241239 241240 241241 241242 241243 241244 241245 241246 241247 241248 241249 241250 241251 241252 241253 241254 241255 241256 241257 241774 241775 242397 242398 243585 243586 243588 244244 244245 244246 244247 244248 244249 249032 256772 256838 256839 256886 256917 256988 256989 257003 257004 257005 257006 257007 257008 257009 257014 257015 257016 257017 257019 257020 257021 257022 257023 257024 257032 257033 257034 257037 257069 257071 259681 260103 260104 260105 261751 261774 267739 267740 267741 267743 267744 267752 267753 267754 267755 267756 267757 267758 267759 285245 285246 285458 285459 285460 289049 289050 289051 289052 302401 308990 312052 314069 317662 317663 325314 325315 328132 335297 335298 336077 339571 339583 339597 339598 339599 339600 339601 339602 339603 339604 339605 339606 339607 339608 339609 339610 339611 341490 341494 345099 346297 353988 403605 403606 403608 403609 403610 403611 403652 403653 403654 403655 403656 403657 403665 403675 403702 403710 403745 403765 403770 403772 403807 403808 403812 403866 404304 404305 404306 404417 404423 404604 404605 404606 404607 404640 404783 404785 404786 404819 404828 404829 404834 404873 404874 404881 404883 404904 404907 404911 404912 404998 404999 405000 405429 405430 405431 406560 411994 411996 411997 411998 411999 412000 413346 413354 413355 413356 413357 413358 413359 413696 465893 465894 469476 469488 469489 469491 469492 504312 508236 519637 519638 519639 1 ] |
|
5.82 ms (15.09%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[ 52 245 246 247 248 ] |
|
3.34 ms (8.66%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[ 52 245 246 247 248 ] |
|
2.73 ms (7.08%) |
18 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
1
]
|
|
1.78 ms (4.63%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 52 245 246 247 248 2786 2788 3023 3032 3033 3037 3038 3042 3043 3047 3048 3050 3053 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 4376 5707 5712 ] |
|
0.94 ms (2.45%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
"classement-archivage-presentation-de-documents"
]
|
|
0.44 ms (1.14%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 30
Parameters:
[ 52 245 246 247 248 ] |
|
0.39 ms (1.02%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"classement-archivage-presentation-de-documents"
]
|
|
0.35 ms (0.90%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = ?
Parameters:
[
"classement-archivage-presentation-de-documents"
]
|
|
0.27 ms (0.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.25 ms (0.64%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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 |
|---|---|
| App\Entity\Product\Product | No errors. |
| App\Entity\Product\ProductPrice | No errors. |
| App\Entity\Pricing\Price | No errors. |
| App\Entity\Product\Category | No errors. |
| App\Entity\Pricing\Promotion | No errors. |
| App\Entity\Catalog\ProductCatalog | No errors. |
| App\Entity\Catalog\CustomerCatalog | No errors. |
| App\Entity\PromotionalOperations\Operation | No errors. |
| App\Entity\Product\ProductMarket | No errors. |
| App\Entity\Product\Characteristic | No errors. |
| App\Entity\Personalization\ColorInkModel | No errors. |
| App\Entity\Personalization\ColorCustom | No errors. |
| App\Entity\Personalization\PoliceModelCustom | No errors. |
| App\Entity\Personalization\GlobalPersonnalization | No errors. |
| App\Entity\Personalization\ModelCustom | No errors. |
| App\Entity\RubberStamp\RubberStampCustom | No errors. |
| App\Entity\Product\CharacteristicLabel | No errors. |