Query Metrics
227
Database Queries
23
Different statements
1398.79 ms
Query time
0
Invalid entities
1734
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
737.22 ms (52.70%) |
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 customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[ 6385507 6388858 6390967 6391498 6391818 6392024 6393204 6393930 6396473 6396770 6397042 6397478 6398406 6399093 6403507 6403865 6406841 6407076 6407133 6408612 6410776 6417429 6417694 6418609 6421751 6422386 6422520 6422644 6423077 6425270 6427462 6428668 6429488 6429970 6430129 6430130 6430131 6430132 6430133 6430134 6430135 6430136 6430137 6430138 6430139 6430140 6430141 6430142 6430143 6430144 6430145 6430146 6430147 6430148 6430149 6430150 6430151 6430152 6430153 6430154 6430155 6430156 6430157 6430158 6430159 6430160 6430161 6430162 6430163 6430164 6430165 6430166 6430167 6430168 6430169 6430170 6430171 6430172 6430173 6430174 6430175 6430176 6430177 6430178 6430179 6430180 6430181 6430182 6430183 6430184 6430335 6430435 6430564 6431493 6431503 6433424 6433821 6434367 6434696 6437631 6438665 6440293 6440294 6440295 6440296 6440297 6440298 6440299 6440300 6440303 6440304 6440305 6440306 6440307 6440308 6440309 6440310 6440311 6440312 6440313 6440314 6440315 6440316 6440317 6440318 6440319 6440320 6440321 6440322 6440323 6440324 6440325 6440326 6440327 6440328 6440329 6440330 6440331 6440332 6440333 6440334 6440335 6440337 6440338 6440339 6440340 6440341 6440342 6440343 6440344 6440345 6440346 6440347 6440348 6440349 6440350 6440351 6440352 6440353 6443140 6443768 6444277 6445253 6445333 6448273 6448858 6450297 6452108 6452659 6453207 6453621 6454561 6454705 6455110 6455119 6456342 6456344 6456429 6457390 6457397 6459945 6459946 6463419 6464644 6465254 6469414 6469419 6469650 6470292 6472851 6473274 6473280 6475676 6477644 6477899 6478140 6478156 6478169 6478976 6479466 6479887 6480347 6480451 6480459 6480472 6480503 6480550 6480596 6481204 6481220 6481241 6481274 6481372 6481392 6481413 6481471 6481505 6481547 6481588 6483010 6483026 6483080 6483107 6483123 6483236 6485628 6485957 6486629 6487108 6487232 6487274 6487278 6487785 6488024 6488025 6488026 6488027 6488028 6488029 6488030 6488031 6488032 6488033 6488034 6488035 6488036 6488037 6488038 6488039 6488040 6488041 6488042 6488043 6488044 6488046 6488047 6488048 6488049 6488050 6488051 6488052 6488053 6488109 6488110 6488111 6488112 6488113 6488114 6488115 6488116 6488117 6488118 6488119 6488120 6488121 6488122 6488123 6488124 6488125 6488126 6488127 6488128 6488129 6488130 6488131 6488132 6488133 6488134 6488135 6488137 6488138 6488145 6488146 6488147 6488148 6488149 6488150 6488151 6488152 6488153 6488154 6488156 6488392 6488473 6488526 6488566 6491333 6491335 6491364 6491365 6491577 6491599 6491614 6491666 6491794 6491796 6497143 6497616 6498529 6499389 6499673 6499714 6499896 6500649 6501314 6501319 6501320 6501325 6501326 6501329 6501333 6501336 6501339 6501341 6501347 6501349 6501351 6501353 6501354 6501355 6501356 6501357 6501358 6501360 6501361 6502073 6504079 6506345 6507672 6507674 6507737 6508089 6508090 6508091 6508092 6508093 6508094 6508095 6508096 6508097 6508098 6508099 6508100 6508101 6508102 6508103 6508104 6508105 6508106 6508107 6508108 6508109 6508110 6508111 6508112 6508113 6508115 6508116 6508117 6508118 6508119 6508123 6508124 6508125 6508126 6508127 6508128 6508129 6508130 6508131 6508132 6508133 6508134 6508189 6508190 6508191 6508192 6508193 6508194 6508195 6508196 6508197 6508198 6508199 6508200 6508201 6508202 6508203 6508204 6508205 6508206 6508207 6508208 6508209 6508210 6508211 6508212 6508213 6508214 6508215 6508216 6508217 6508218 6508219 6508220 6509102 6510279 6510298 6515181 6515231 6515892 6515893 6516972 6516984 6516994 6517030 6517041 6517054 6517247 6517268 6517275 6517279 6517363 6517451 6517482 6517854 6517856 6518447 6520308 6523725 6523726 6525552 6527950 6527953 6527954 6527955 6527961 6527972 6527980 6527983 6527984 6527985 6527988 6527989 6527990 6527993 6527994 6527995 6527998 6527999 6528001 6529429 6529493 6529494 6529495 6529496 6529497 6529498 6529499 6529500 6529501 6529502 6529503 6529504 6529505 6529506 6529507 6529508 6529509 6529510 6529511 6529512 6529513 6529514 6529515 6529516 6529517 6529518 6529519 6529520 6529521 6529522 6529523 6529524 6529577 6529578 6529579 6529580 6529581 6529582 6529583 6529584 6529585 6529586 6529587 6529588 6529589 6529590 6529591 6529592 6529593 6529594 6529595 6529596 6529597 6529598 6529599 6529600 6529601 6529602 6529603 6529604 6529605 6529606 6529607 6529608 6529609 6529610 6529611 6529612 6529613 6529614 6529615 6529616 6529617 6529618 6530420 6530558 6531252 6534209 6534230 6535584 6540379 1000012577 1000013922 1000013926 1000012456 1000014363 1000014131 1000017346 1000009626 1000018133 1000022110 1000017258 6343267 1000032312 1000034787 1000034842 1000034852 1000034853 1000044387 1000044388 1000044640 1000044647 1000044648 1000044649 1000044828 1000044832 1000044836 1000044895 1000044899 1000044900 1000044901 1000044902 1000044933 1000045731 1000045732 1000045733 1000045734 1000045735 1000045736 1000045737 1000045738 1000045739 1000045740 1000045741 1000045742 1000045743 1000045744 1000045745 1000045746 1000045748 1000045749 1000045750 1000048022 1000048358 1000048299 1000050239 1000051571 1000051641 1000051644 1000051649 1000051651 1000051668 1000051672 1000051674 1000051680 1000051754 1000051772 1000051773 1000051916 1000051982 1000052011 1000052052 1000052055 1000052056 1000052057 1000052070 1000052071 1000052132 1000052135 1000052148 1000052150 1000052210 1000052271 1000052272 1000052273 1000052276 1000052278 1000052389 1000034883 1000052421 1000052422 1000052658 1000052661 1000052709 1000052730 1000052828 1000052846 1000052848 1000052853 1000052855 1000052856 1000052857 1000052899 1000052904 1000052910 1000052956 1000053039 1000053080 1000053432 1000053441 1000051727 1000053462 1000053601 1000053602 1000053805 1000053808 1000053809 1000053810 1000053866 1000053868 1000053870 1000053872 1000053875 1000054041 1000054042 1000054044 1000054133 1000054139 1000054132 1000054159 1000054403 1000054557 1000054559 1000054561 1000054567 1000054569 1000054587 1000054855 1000055177 1000055217 1000055255 1000055259 1000055276 1000055359 1000055392 1000055393 1000055683 1000055788 1000055789 1000055790 1000055791 1000055792 1000055686 1000055896 1000056137 1000056245 1000056248 1000056264 1000056396 1000056397 1000056405 1000056434 1000056436 1000056437 1000056439 1000056518 1000056750 1000056752 1000056753 1000056795 1000056799 1000056800 1000056801 1000056967 1000056968 1000054129 1000057316 1000057401 1000057410 1000057412 1000057554 1000057555 1000057588 1000057589 1000057590 1000057591 1000057593 1000057707 1000058066 1000058069 1000058125 1000058162 1000058163 1000058170 1000058178 1000058179 1000058180 1000058181 1000058175 1000058182 1000058602 1000058897 1000058901 1000058927 1000059182 1000059341 1000059342 1000059343 1000059346 1000059349 1000059350 1000059354 1000059370 1000059711 1000059712 1000059713 1000059719 1000059720 1000059721 1000059737 1000059738 1000059739 1000059559 1000059860 1000059974 1000060134 1000060188 1000060216 1000060283 1000060407 1000060617 1000060619 1000060621 1000060622 1000060623 1000060624 1000060672 1000060674 1000060676 1000061017 1000061018 1000061019 1000061033 1000061149 1000061151 1000061152 1000061153 1000062223 1000062415 1000063929 1000063933 1000063934 1000065428 1000066402 28691 ] |
|
459.82 ms (32.87%) |
1 |
SELECT c0_.id AS id_0, c0_.temporary_cart_number AS temporary_cart_number_1, c0_.type AS type_2, c0_.number AS number_3, c0_.slip AS slip_4, c0_.status AS status_5, c0_.order_picker AS order_picker_6, c0_.created_at AS created_at_7, c0_.delivery_date AS delivery_date_8, c0_.login AS login_9, c0_.user_reference AS user_reference_10, c0_.tracking_number AS tracking_number_11, c0_.deposit AS deposit_12, c0_.sector AS sector_13, c0_.sub_sector AS sub_sector_14, c0_.customer_name AS customer_name_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.address3 AS address3_18, c0_.zip_code AS zip_code_19, c0_.city AS city_20, c0_.country AS country_21, c0_.phone AS phone_22, c0_.fax AS fax_23, c0_.email AS email_24, c0_.customer_name_delivery AS customer_name_delivery_25, c0_.address1_delivery AS address1_delivery_26, c0_.address2_delivery AS address2_delivery_27, c0_.address3_delivery AS address3_delivery_28, c0_.zip_code_delivery AS zip_code_delivery_29, c0_.delivery_city AS delivery_city_30, c0_.country_delivery AS country_delivery_31, c0_.delivery_phone AS delivery_phone_32, c0_.fax_delivery AS fax_delivery_33, c0_.email_delivery AS email_delivery_34, c0_.reglement AS reglement_35, c0_.updated_at AS updated_at_36, c0_.price_ht AS price_ht_37, c0_.price_tva AS price_tva_38, c0_.price_ttc AS price_ttc_39, c0_.price_cost_ht AS price_cost_ht_40, c0_.display_ttc AS display_ttc_41, c0_.package_number AS package_number_42, c0_.weight AS weight_43, c0_.volume AS volume_44, c0_.discount AS discount_45, c0_.feedback AS feedback_46, c0_.global_discount AS global_discount_47, c0_.commitment_number AS commitment_number_48, c0_.promotional_code AS promotional_code_49, c0_.multiplier_coefficient AS multiplier_coefficient_50, c0_.is_out_of_budget AS is_out_of_budget_51, c0_.lead_word AS lead_word_52, c0_.facturation AS facturation_53, c0_.complete_delivery AS complete_delivery_54, c0_.urgent_delivery AS urgent_delivery_55, c0_.complete_facturation AS complete_facturation_56, c0_.paypal AS paypal_57, c0_.regroupement AS regroupement_58, c0_.transaction AS transaction_59, c0_.plate_number AS plate_number_60, c0_.is_hidden AS is_hidden_61, c0_.budget_id AS budget_id_62, c0_.customer_id AS customer_id_63, c0_.billing_customer_id AS billing_customer_id_64, c0_.user_id AS user_id_65, c0_.delivery_id AS delivery_id_66, c0_.market_id AS market_id_67, c0_.price_id AS price_id_68, c0_.society_id AS society_id_69, c0_.commercial_id AS commercial_id_70, c0_.delivery_cost_id AS delivery_cost_id_71 FROM customer_order c0_ INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id INNER JOIN product p2_ ON c1_.product_id = p2_.id WHERE p2_.id = ? AND c0_.created_at >= ?
Parameters:
[ 28691 "2025-04-12 17:05:47" ] |
|
139.72 ms (9.99%) |
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:
[
"48653-protege-documents-et-press-book-noir-n-c-806176"
]
|
|
7.91 ms (0.57%) |
22 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 2786 ] |
|
7.29 ms (0.52%) |
35 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
|
7.13 ms (0.51%) |
11 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 2786 7 ] |
|
4.91 ms (0.35%) |
22 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
|
4.83 ms (0.35%) |
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
]
|
|
4.62 ms (0.33%) |
23 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
4.40 ms (0.31%) |
21 |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
28691
]
|
|
3.42 ms (0.24%) |
11 |
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[ 2786 0 ] |
|
3.14 ms (0.22%) |
11 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 2786 "C" ] |
|
2.93 ms (0.21%) |
11 |
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
2786
]
|
|
2.80 ms (0.20%) |
11 |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-09-12 17:05:48" "%2%" 2786 ] |
|
2.79 ms (0.20%) |
9 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 2786 9957571 ] |
|
2.25 ms (0.16%) |
11 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
2786
]
|
|
0.68 ms (0.05%) |
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_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 52 245 246 247 248 247 28691 ] |
|
0.58 ms (0.04%) |
2 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
9845
]
|
|
0.55 ms (0.04%) |
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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"48653-protege-documents-et-press-book-noir-n-c-806176"
]
|
|
0.54 ms (0.04%) |
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 = ? AND c1_.is_display_site = ?
Parameters:
[ 28691 1 ] |
|
0.49 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
28691
]
|
|
0.39 ms (0.03%) |
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:
[
"48653-protege-documents-et-press-book-noir-n-c-806176"
]
|
|
0.38 ms (0.03%) |
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
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Order\CustomerOrder | 806 |
| App\Entity\Catalog\ProductCatalog | 213 |
| App\Entity\Catalog\CustomerCatalog | 213 |
| App\Entity\User\User | 97 |
| App\Entity\Delivery\Delivery | 77 |
| App\Entity\Product\ProductPrice | 68 |
| App\Entity\Customer\Customer | 67 |
| App\Entity\Pricing\Price | 49 |
| App\Entity\Product\Market | 29 |
| App\Entity\Internal\Commercial | 28 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 16 |
| App\Entity\Product\CharacteristicLabel | 15 |
| App\Entity\Delivery\DeliveryCost | 6 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Internal\Parameter | 3 |