Query Metrics
114
Database Queries
22
Different statements
1833.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
878.64 ms (47.91%) |
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:
[ 60414 "2025-02-12 23:33:49" ] |
|
868.10 ms (47.34%) |
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:
[ 6340832 6343632 6344136 6344556 6335660 6346285 6346459 6347258 6347302 6349919 6350250 6351132 6351591 6352305 6352569 6356317 6356318 6356319 6356320 6356321 6356322 6356323 6356324 6356326 6356327 6356328 6356329 6356330 6356331 6356332 6356333 6356334 6356335 6356336 6356337 6356338 6356339 6356340 6356341 6356342 6356343 6356344 6356345 6356346 6356347 6356348 6356349 6356351 6356352 6356353 6356354 6356355 6356356 6356357 6356358 6356359 6356360 6356361 6356362 6356363 6356364 6356365 6356367 6356368 6356369 6356370 6356371 6356372 6356374 6356375 6356376 6356377 6356378 6356379 6356380 6356381 6356382 6356384 6356385 6356386 6356387 6356388 6356389 6356390 6356391 6356392 6356393 6356394 6356395 6356396 6356397 6356398 6356399 6356400 6356401 6356402 6356403 6356404 6356405 6356406 6356407 6356408 6356409 6356410 6356411 6356412 6356413 6356414 6356415 6356416 6356417 6356418 6356419 6356420 6356421 6356422 6356423 6356424 6356425 6356426 6356427 6356428 6356429 6356430 6356431 6356432 6358230 6360459 6360582 6364027 6365211 6365209 6365272 6365548 6365718 6366596 6367153 6367154 6367155 6367156 6367157 6367158 6367159 6367160 6367161 6367162 6367163 6367164 6367165 6367166 6367167 6367168 6367169 6367170 6367171 6367172 6367173 6367174 6367175 6367176 6367177 6367178 6367179 6367180 6367181 6367182 6367183 6367184 6367185 6367186 6367187 6367188 6367189 6367190 6367191 6367192 6367193 6367194 6367195 6367196 6367197 6367198 6367199 6367200 6367201 6367202 6367203 6367204 6367205 6367206 6367207 6367208 6367209 6367210 6367211 6367212 6367213 6367214 6367215 6367216 6367217 6367218 6367219 6367220 6367221 6367222 6367223 6367224 6367225 6367226 6367227 6367228 6367229 6367230 6367231 6367232 6367233 6367234 6367236 6367237 6367238 6367239 6367240 6367241 6367242 6367243 6367244 6367245 6367246 6367247 6367248 6367249 6367250 6367251 6367253 6367254 6367255 6367256 6367257 6367258 6367259 6367260 6367261 6367262 6367263 6367264 6367265 6367266 6369842 6370239 6370581 6371176 6372090 6372293 6373704 6376992 6377780 6378665 6380206 6380191 6367609 6374223 6382464 6382804 6383394 6383684 6385412 6385508 6385705 6383823 6380678 6388481 6386755 6389179 6389302 6387470 6390534 6390340 6391091 6391259 6390792 6392012 6392027 6392092 6392145 6392180 6387952 6392443 6392471 6393401 6393413 6393591 6393699 6393734 6394109 6394150 6394260 6394317 6394575 6394713 6394825 6395024 6395484 6398619 6398730 6398735 6398832 6398848 6399786 6400237 6400499 6400560 6400563 6401570 6401686 6403379 6403789 6407160 6410889 6410950 6411868 6412087 6412304 6412554 6412665 6413643 6413717 6414284 6414750 6415714 6415856 6415949 6416035 6416071 6416257 6416390 6416877 6416886 6416898 6416941 6417318 6417580 6418380 6418843 6418893 6419184 6419241 6419273 6419324 6419353 6419569 6419992 6420262 6420413 6420424 6421078 6422657 6424405 6425324 6425424 6425450 6425557 6425775 6426324 6426424 6426484 6426889 6426942 6426965 6427231 6428282 6428410 6428672 6429414 6429572 6429624 6430330 6430389 6430477 6430871 6430880 6430929 6431497 6431536 6431849 6431926 6432208 6432335 6433472 6433875 6433944 6434204 6434669 6434767 6434805 6435351 6435988 6436027 6436283 6436451 6436996 6437012 6438087 6438113 6438825 6438841 6439198 6439659 6439949 6441208 6442258 6442584 6442675 6442751 6442876 6442976 6443728 6443902 6443903 6444240 6445016 6445036 6445111 6445157 6445278 6445271 6445352 6445534 6445642 6445772 6446038 6446613 6446956 6448576 6448853 6448936 6448956 6449010 6449398 6449463 6449897 6450106 6450191 6450253 6450429 6450496 6450579 6450587 6450613 6451081 6451086 6451093 6451094 6451440 6451493 6451659 6451664 6451806 6451922 6452010 6452037 6452048 6452319 6452418 6452510 6452610 6452614 6452617 6452830 6452895 6453140 6453263 6453327 6453403 6453556 6454180 6454587 6454665 6454759 6454810 6454881 6454882 6454930 6454985 6455076 6455192 6455354 6455466 6455626 6455628 6455636 6455650 6455695 6455805 6456106 6456252 6456673 6456988 6457072 6457206 6457231 6457645 6457647 6457684 6457768 6457788 6459437 6459444 6459486 6459612 6460042 6461305 6462717 6462973 6463097 6463207 6463212 6463215 6463219 6463227 6463607 6463739 6463960 6463974 6464256 6464351 6464353 6464841 6465294 6465683 6466360 6466636 6466672 6466778 6467015 6467176 6467826 6468042 6468043 6468576 6468695 1000000890 6394821 1000001549 1000003839 6389512 1000007907 1000001639 1000008178 1000008211 1000008419 1000008866 1000008454 1000008922 1000001743 1000009289 1000009627 1000007909 1000009910 1000009641 1000010534 1000006894 1000010951 1000011830 1000012638 1000012640 1000013100 1000013102 1000012623 1000013980 1000004333 1000014515 1000014633 1000013554 1000006614 1000013475 1000014283 1000012347 1000009671 1000015654 1000014867 1000015832 1000016183 1000014287 1000016874 1000016876 1000015673 1000007022 1000017528 1000017545 1000017546 1000019550 1000012630 1000018789 1000016836 1000020191 1000020202 1000020205 1000020206 1000020207 1000020214 1000020215 1000020244 1000020252 1000017170 1000020262 1000020277 1000020280 1000021003 1000021209 1000021210 1000021244 1000021247 1000012314 1000021250 1000021262 1000021264 1000021289 1000021450 1000021452 6392486 1000021565 1000021568 1000021571 1000021713 1000021715 1000002172 1000016210 1000014496 1000015699 1000023455 1000017356 6378270 1000024606 1000025170 1000025496 1000025578 1000025833 1000026180 1000026357 1000026361 1000026366 1000026497 1000026499 1000026557 1000026146 1000027132 1000027156 1000027214 1000027264 1000027265 1000027266 1000027270 1000027350 1000027353 1000027354 1000027356 1000027357 1000013802 1000027438 1000027512 1000027515 1000027516 1000027517 1000027518 1000027519 1000027521 1000027524 1000012267 1000028685 1000029081 1000012381 1000029087 1000025609 1000030069 1000022840 1000030701 1000030752 1000030834 1000011967 1000031698 1000031700 1000028298 1000031849 1000031902 1000031918 1000031919 1000031924 1000032052 1000032085 1000032252 1000032281 1000032308 1000032309 1000032310 1000032322 1000032323 1000032336 1000032370 1000032375 1000032378 1000032433 1000032443 1000032445 1000032501 1000032521 1000033191 1000033193 1000033198 1000033324 1000033327 1000033335 5869416 1000027138 1000033828 1000034171 1000034606 1000034757 1000034758 1000034759 1000035146 1000033522 1000035797 1000035860 1000035863 1000035972 1000036045 1000036047 1000036049 1000036050 1000036086 1000024806 1000018396 1000036205 1000036225 1000036228 1000027017 1000038226 1000038602 1000038876 1000038877 1000038880 1000038882 1000038885 1000038886 1000038887 1000038889 1000038891 1000038903 1000038909 1000038932 1000038933 1000038940 1000038941 1000038945 1000038957 1000038958 1000038963 1000038996 1000039003 1000039018 1000039028 1000039066 1000039067 1000039098 1000039509 1000039510 1000039511 1000039516 1000039523 1000039526 1000039539 1000039548 1000039565 1000014103 1000029363 1000017098 1000022801 1000028250 1000042566 1000037837 1000042750 1000038229 1000041721 1000041916 1000043230 1000043282 1000043288 1000043289 1000040973 1000044134 1000044343 1000044349 1000044353 1000044356 1000044358 1000044395 1000044487 1000044537 1000044598 1000044681 1000044769 1000044908 1000031927 1000043280 1000045655 1000045665 1000045666 1000045668 1000045683 1000045684 1000045716 1000045717 1000045722 1000045723 1000045726 1000041220 1000046052 1000046353 1000046956 1000046960 1000046962 1000046970 1000046973 1000046974 1000046975 1000046976 1000046977 1000046987 1000047023 1000047158 1000047341 1000047357 1000047361 1000047373 1000025139 1000047587 1000033122 1000047776 1000047778 1000032215 1000047798 1000045634 1000047952 1000012406 1000048106 1000048107 1000039792 1000048172 1000048689 1000048738 1000048347 1000048806 1000048829 1000048853 1000047364 1000048357 1000048914 1000049136 1000048958 1000049321 1000049205 1000049471 1000049469 1000049732 1000049739 1000049740 1000049830 1000044980 1000049901 1000044463 1000049960 1000048235 1000050276 1000050428 1000050431 1000050654 1000050691 1000033359 1000050696 1000049192 1000048898 1000050326 1000048190 1000050990 1000050999 1000051036 1000050205 1000051247 1000051324 1000051352 1000051474 1000051491 1000051494 1000050084 1000048611 1000051561 1000051664 1000050959 1000051686 1000051842 1000051966 1000051980 1000049144 1000052380 1000052461 1000052467 1000052707 1000052708 1000053122 1000049647 1000052460 1000052134 1000053475 1000053490 60414 ] |
|
52.82 ms (2.88%) |
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:
[
"56839-ciseaux-couleur-n-c-fci132091"
]
|
|
5.38 ms (0.29%) |
5 |
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:
[
60414
]
|
|
5.30 ms (0.29%) |
5 |
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:
[ 60414 0 ] |
|
3.67 ms (0.20%) |
10 |
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" 60414 ] |
|
3.42 ms (0.19%) |
17 |
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"
]
|
|
2.83 ms (0.15%) |
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
]
|
|
2.16 ms (0.12%) |
10 |
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"
]
|
|
1.79 ms (0.10%) |
10 |
SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ?
Parameters:
[
198101
]
|
|
1.65 ms (0.09%) |
5 |
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:
[ 60414 "C" ] |
|
1.60 ms (0.09%) |
11 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.29 ms (0.07%) |
5 |
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-07-12 23:33:51" "%2%" 60414 ] |
|
1.20 ms (0.07%) |
4 |
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:
[ 80453 9963416 ] |
|
0.75 ms (0.04%) |
4 |
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:
[
80453
]
|
|
0.72 ms (0.04%) |
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:
[ 55 259 260 261 262 263 264 260 60414 ] |
|
0.56 ms (0.03%) |
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:
[
"56839-ciseaux-couleur-n-c-fci132091"
]
|
|
0.44 ms (0.02%) |
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.43 ms (0.02%) |
1 |
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:
[
60414
]
|
|
0.43 ms (0.02%) |
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:
[ 60414 1 ] |
|
0.33 ms (0.02%) |
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:
[
"56839-ciseaux-couleur-n-c-fci132091"
]
|
|
0.28 ms (0.02%) |
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:
[
60414
]
|
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.