Query Metrics
81
Database Queries
23
Different statements
1372.46 ms
Query time
0
Invalid entities
1385
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
768.59 ms (56.00%) |
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:
[ 6364548 6364621 6364701 6405744 6405745 6405746 6405747 6405748 6405749 6405750 6405751 6405752 6405753 6405754 6405755 6405756 6405757 6405758 6405759 6405760 6405761 6405762 6405764 6405765 6405766 6405767 6405768 6405769 6405770 6405772 6405773 6405774 6405775 6405776 6405777 6405778 6405779 6405780 6405781 6405782 6405783 6405786 6405787 6405788 6405789 6405790 6405791 6405792 6405793 6405794 6405795 6405796 6405797 6405798 6405799 6405800 6405801 6405802 6405803 6405804 6405805 6405806 6405807 6405808 6405809 6405810 6405811 6405812 6405813 6405814 6405815 6405816 6405817 6405818 6405819 6405820 6405821 6405822 6405823 6405824 6405825 6405826 6405827 6405828 6405829 6405830 6405831 6405832 6405833 6405834 6405835 6405836 6405837 6405838 6405839 6405841 6405842 6405843 6405844 6405845 6405846 6405847 6405848 6405849 6405850 6405851 6405852 6405853 6405854 6405855 6405856 6405857 6405858 6405859 6405860 6405861 6405862 6405863 6405864 6405865 6405866 6405867 6405868 6405869 6405870 6405871 6405872 6405873 6405874 6405875 6405876 6405877 6405878 6405879 6405880 6405881 6405883 6405884 6407164 6407165 6407166 6407167 6407168 6407169 6407170 6407171 6407172 6407173 6407175 6407176 6407177 6407178 6407179 6407180 6407181 6407182 6407183 6407184 6407185 6407187 6407188 6407189 6407190 6407191 6407192 6407193 6407194 6407195 6407196 6407198 6407199 6407200 6407201 6407202 6407203 6407204 6407205 6407206 6407207 6407208 6407209 6407210 6407211 6407212 6407213 6407215 6407216 6407217 6407218 6407219 6407221 6407222 6407223 6407224 6407225 6407226 6407227 6407228 6407229 6407230 6407231 6407232 6407233 6407236 6407237 6407238 6407239 6407240 6407242 6407243 6407244 6407245 6407246 6407247 6407248 6407249 6407250 6407251 6407252 6407253 6407254 6407255 6407256 6407258 6407259 6407260 6407261 6407262 6407263 6407264 6407265 6407267 6407268 6407269 6407270 6407271 6407272 6407279 6407280 6407281 6407282 6407283 6407284 6407286 6407287 6407288 6407289 6407290 6407291 6407292 6407293 6407294 6407295 6407296 6407297 6407298 6407299 6407300 6407301 6407302 6407303 6407304 6407305 6407306 6407307 6407308 6407309 6407310 6407312 6407313 6407314 6407315 6407316 6407318 6407319 6407320 6408612 6408955 6411799 6411800 6411804 6411806 6412624 6412636 6413897 6413900 6413902 6413904 6413907 6420643 6420869 6420910 6421104 6421411 6421441 6421442 6421443 6421444 6421445 6421446 6421447 6421449 6421451 6421453 6421454 6421455 6421456 6421457 6421460 6421461 6424344 6424462 6424465 6424468 6424469 6424470 6424471 6424472 6424473 6424474 6424475 6424476 6424477 6424478 6424479 6424480 6424484 6424485 6424486 6426346 6428234 6428238 6428244 6428246 6434837 6434847 6434858 6434865 6446663 6451611 6451612 6452175 6452176 6452177 6452178 6462852 6464303 6468224 6468227 6469266 6469290 6469300 6469310 6469398 6469402 6469429 6469591 6472378 6472392 6472422 6472471 6472488 6472510 6472541 6478140 6478156 6478169 6478317 6478976 6479466 6479887 6480347 6480459 6480472 6480485 6480503 6480520 6480550 6480573 6480596 6480665 6480680 6481220 6481241 6481274 6481297 6481341 6481372 6481392 6481413 6481437 6481471 6481505 6481547 6481588 6483010 6483026 6483046 6483080 6483107 6483123 6483132 6485018 6485021 6485574 6485599 6485616 6485628 6487108 6488162 6488302 6488309 6488392 6488415 6488439 6488473 6488526 6488566 6491577 6491599 6491614 6491666 6491794 6492875 6493982 6493983 6493984 6493985 6493986 6493987 6493988 6493989 6493990 6493991 6493992 6493993 6493994 6493995 6493996 6493997 6493998 6493999 6494000 6494001 6494002 6494003 6494004 6494005 6494006 6494007 6494008 6494009 6494010 6494011 6494012 6494013 6494014 6494015 6494016 6494017 6494018 6494020 6494021 6494022 6494023 6494024 6494025 6494026 6494027 6494028 6494029 6494030 6494031 6494032 6494033 6494034 6494035 6494036 6494037 6494038 6494039 6494040 6494041 6494042 6494043 6494044 6494045 6494046 6494047 6494048 6494049 6494050 6494428 6494431 6494708 6495863 6495997 6495998 6495999 6496000 6496001 6496002 6496003 6496004 6496005 6496006 6496007 6496008 6496009 6496010 6496011 6496012 6496013 6496014 6496015 6496016 6496017 6496018 6496019 6496020 6496021 6496022 6496023 6496024 6496025 6496026 6496027 6496028 6496029 6496030 6496031 6496032 6496033 6496034 6496035 6496036 6496037 6496038 6496039 6496040 6496041 6496042 6496043 6496045 6496046 6496047 6496048 6496049 6496050 6496051 6496052 6496053 6496054 6496055 6496056 6496057 6496058 6496059 6496060 6496061 6496062 6496063 6496064 6496065 6496066 6496067 6496198 6497157 6497191 6499112 6501313 6501314 6501315 6501316 6501318 6501319 6501320 6501325 6501326 6501327 6501328 6501333 6501336 6501339 6501340 6501341 6501342 6501344 6501346 6501347 6501349 6501351 6501353 6501354 6501355 6501356 6501357 6501358 6501359 6501360 6501361 6501362 6507161 6507799 6507819 6507853 6507856 6508709 6508741 6510279 6510298 6510303 6510312 6510313 6510315 6510318 6510320 6510323 6510331 6510693 6511173 6515181 6515231 6515606 6515608 6515638 6515640 6515654 6515658 6515671 6515672 6515712 6515713 6515718 6515719 6515722 6515724 6515734 6515736 6515754 6515755 6515766 6515767 6515793 6515795 6515996 6515997 6516972 6516984 6516994 6517007 6517030 6517041 6517054 6517247 6517268 6517275 6517279 6517363 6517373 6517396 6517430 6517451 6517473 6517482 6517854 6517856 6518244 6518248 6518344 6518347 6518480 6518481 6518611 6518622 6518623 6519274 6519275 6519283 6519286 6519297 6519298 6519312 6519314 6519476 6519477 6519525 6519527 6519545 6519548 6519859 6520106 6520139 6520140 6524297 6525123 6525767 6527406 6527420 6527951 6527952 6527953 6527954 6527955 6527956 6527959 6527960 6527961 6527962 6527964 6527965 6527966 6527967 6527968 6527970 6527972 6527975 6527977 6527979 6527980 6527983 6527984 6527985 6527987 6527988 6527989 6527990 6527993 6527994 6527995 6527997 6527998 6527999 6528001 6530159 1000022294 1000041590 1000041591 1000041592 1000041593 1000041595 1000041596 1000041602 1000041603 1000041611 1000045783 1000049349 1000047122 1000051591 1000051637 1000051638 1000051641 1000051644 1000051649 1000051651 1000051668 1000051672 1000051673 1000051674 1000051675 1000051679 1000051680 1000051793 1000051794 1000051814 1000051916 1000051982 1000052052 1000052055 1000052056 1000052057 1000052070 1000052071 1000052114 1000052132 1000052135 1000052148 1000052150 1000052185 1000052188 1000052210 1000052271 1000052272 1000052273 1000052276 1000052278 1000052389 1000052406 1000052411 1000052412 1000052421 1000052422 1000052644 1000052646 1000052648 1000052658 1000052661 1000052709 1000052730 1000052828 1000052846 1000052848 1000052850 1000052851 1000052853 1000052855 1000052856 1000052857 1000052899 1000052904 1000052910 1000052956 1000053039 1000053080 1000053432 1000053441 1000051727 1000053462 1000053601 1000053602 1000053681 1000053744 1000053805 1000053808 1000053809 1000053810 1000053866 1000053868 1000053870 1000053872 1000053875 1000054041 1000054042 1000054044 1000054133 1000054139 1000054132 1000054159 1000054200 1000054403 1000054512 1000054557 1000054559 1000054561 1000054567 1000054569 1000054587 1000054855 1000054946 1000055086 1000055177 1000055217 1000055252 1000055255 1000055259 1000055276 1000055359 1000055369 1000055392 1000055393 1000055683 1000055788 1000055789 1000055790 1000055791 1000055792 1000055822 1000055823 1000055824 1000055826 1000055895 1000055900 1000055902 1000055913 1000055958 1000055984 1000055997 1000056080 1000056081 1000056137 1000056160 1000056163 1000056245 1000056248 1000056264 1000056328 1000056329 1000056330 1000056333 1000056331 1000056340 1000056342 1000056350 1000056396 1000056397 1000056405 1000056433 1000056434 1000056436 1000056437 1000056439 1000056478 1000056479 1000056518 1000056595 1000056681 1000056750 1000056752 1000056753 1000056769 1000056770 1000056795 1000056967 1000056968 1000054129 1000057057 1000057346 1000057347 1000057401 1000057410 1000057412 1000057554 1000057555 1000057570 1000057580 1000057588 1000057589 1000057590 1000057591 1000057593 1000057752 1000057768 1000056748 1000058066 1000058069 1000058090 1000058113 1000058125 1000058128 1000058129 1000058130 1000058131 1000058132 1000058133 1000058162 1000058163 1000058170 1000058178 1000058179 1000058180 1000058181 1000058175 1000058182 1000058282 1000058595 1000058602 1000058822 1000058897 1000058901 1000058917 1000058919 1000058920 1000058927 1000059005 1000059074 1000059118 1000059122 1000059180 1000059183 1000059182 1000059242 1000059341 1000059342 1000059343 1000059346 1000059349 1000059350 1000059354 1000059370 1000059449 1000059451 1000059452 1000059461 1000059462 1000059489 1000059665 1000059692 1000059693 1000059694 1000059695 1000059696 1000059711 1000059712 1000059713 1000059719 1000059720 1000059721 1000059753 1000059810 1000059816 1000059835 1000059846 1000059856 1000059860 1000059862 1000059877 1000059889 1000059890 1000059925 1000059929 1000059930 1000059974 1000060134 1000060216 1000060283 1000060320 1000060322 1000060342 1000060407 1000060518 1000060617 1000060619 1000060621 1000060622 1000060623 1000060624 1000060637 1000060638 1000060670 1000060672 1000060674 1000060676 1000060758 1000060906 1000060907 1000061012 1000061017 1000061018 1000061019 1000061033 1000061040 1000061077 1000061079 1000061149 1000061151 1000061152 1000061153 1000061177 1000061226 1000061233 1000061234 1000061245 1000061246 1000061269 1000061384 1000061422 1000061636 1000061637 1000061638 1000061719 1000061884 1000061885 2704 ] |
|
573.98 ms (41.82%) |
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:
[ 2704 "2025-04-12 12:04:11" ] |
|
7.22 ms (0.53%) |
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:
[
2704
]
|
|
4.03 ms (0.29%) |
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.52 ms (0.18%) |
4 |
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" 2704 ] |
|
2.44 ms (0.18%) |
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:
[
"16696-pinceaux-et-brosses-couleur-n-c-24152-p"
]
|
|
2.22 ms (0.16%) |
8 |
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"
]
|
|
1.74 ms (0.13%) |
2 |
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:
[ 2704 0 ] |
|
1.52 ms (0.11%) |
2 |
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:
[
2704
]
|
|
1.32 ms (0.10%) |
5 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.14 ms (0.08%) |
4 |
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"
]
|
|
0.71 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:
[ 83 388 389 390 391 392 393 394 395 394 2704 ] |
|
0.66 ms (0.05%) |
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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 2704 7 ] |
|
0.66 ms (0.05%) |
2 |
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:
[ 2704 "C" ] |
|
0.60 ms (0.04%) |
2 |
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 12:04:12" "%2%" 2704 ] |
|
0.51 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:
[
"16696-pinceaux-et-brosses-couleur-n-c-24152-p"
]
|
|
0.47 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
]
|
|
0.39 ms (0.03%) |
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 = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 106184 9963990 ] |
|
0.38 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:
[
"16696-pinceaux-et-brosses-couleur-n-c-24152-p"
]
|
|
0.38 ms (0.03%) |
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:
[ 2704 1 ] |
|
0.35 ms (0.03%) |
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:
[
2704
]
|
|
0.31 ms (0.02%) |
1 |
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:
[
106184
]
|
|
0.31 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:
[
2704
]
|
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 | 1062 |
| App\Entity\User\User | 137 |
| App\Entity\Delivery\Delivery | 50 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Customer\Customer | 17 |
| App\Entity\Pricing\Price | 9 |
| App\Entity\Catalog\ProductCatalog | 9 |
| App\Entity\Catalog\CustomerCatalog | 9 |
| App\Entity\Product\Characteristic | 9 |
| App\Entity\Product\CharacteristicLabel | 9 |
| App\Entity\Internal\Commercial | 9 |
| App\Entity\Product\Market | 7 |
| App\Entity\Product\ProductPrice | 5 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Internal\Parameter | 3 |
| App\Entity\Delivery\DeliveryCost | 3 |