Query Metrics
47
Database Queries
12
Different statements
1546.07 ms
Query time
0
Invalid entities
1725
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
819.10 ms (52.98%) |
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:
[ 634 "2025-04-13 03:29:18" ] |
|
684.53 ms (44.28%) |
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:
[ 6384274 6384304 6384414 6384560 6378321 6385137 6385409 6385500 6385715 6385518 6386474 6386511 6386528 6386782 6386798 6385848 6387173 6387196 6383811 6387369 6387421 6387540 6388191 6383823 6375698 6389133 6390534 6303121 6392140 6393470 6395026 6395224 6395269 6395620 6395724 6395783 6395823 6395839 6396080 6396095 6396985 6397267 6397335 6397534 6397582 6397612 6398076 6398117 6398393 6398397 6398401 6398416 6398507 6398543 6398609 6399981 6403393 6403833 6403907 6404236 6404315 6404678 6404909 6405468 6407039 6407105 1000002769 6407850 6408793 6409215 6410000 6411052 6411813 6412650 6412779 6412945 6413122 6413604 6413695 6413812 6413876 6414660 6416279 6416830 6416900 6416987 6417748 6418057 6418794 6418940 6418990 6419039 6419075 6419275 6419478 6419494 6419565 6420577 6420650 6420986 6422309 6424173 6424620 6426065 6426135 6426535 6426601 6427377 6427696 6427923 6428299 6429190 6430004 6430867 6431588 6432195 6432244 6434624 6434790 6434803 6436027 6437218 6437784 6438104 6438577 6438647 6438666 6438733 6439174 6439422 6439454 6439879 6440949 6442894 6443418 6443439 6443579 6444593 6444605 6444618 6445232 6445317 6445455 6445570 6445623 6446055 6446215 6446525 6446548 6446665 6446925 6447121 6447276 6447501 6447709 6449317 6449376 6449421 6449617 6449829 6449912 6450066 6450188 6450277 6450861 6451032 6451082 6451165 6451310 6451494 6451641 6451650 6452247 6452611 6452830 6453481 6453503 6453978 6454127 6454524 6454659 6454663 6454664 6454873 6454935 6454978 6455066 6455089 6455092 6455103 6455116 6455189 6455307 6455345 6455714 6455822 6455914 6456510 6456673 6457721 6459586 6459705 6459920 6460058 6460158 6460227 6460240 6460405 6460495 6460941 6461163 6461226 6461259 6462666 6462686 6462970 6463028 6463501 6463527 6464057 6464428 6466360 6467050 6467664 6467864 6469829 6470244 6470299 6470503 6470548 6472293 6473153 6473249 6474022 6474652 6476147 6476920 6478180 6480481 6481114 6481140 6481656 6482070 6482785 6483941 6484006 6484545 6488363 6489356 6490052 6490054 6490288 6490676 6490869 6490949 6491037 6491520 6492921 6494508 6495856 6496981 6496997 6497199 6497314 6497471 6497587 6497620 6497663 6497666 6497903 6497934 6498107 6498162 6498306 6498334 6498413 6498424 6499199 6499476 6499677 6500151 6500194 6500260 6500344 6500612 6500692 6500744 6500820 6500830 6500865 6500870 6500876 6500980 6501417 6501430 6501559 6501767 6501822 6501837 6501861 6501871 6501901 6501990 6501994 6502095 6502146 6502197 6502394 6502662 6502816 6503380 6503400 6503514 6504039 6504344 6505473 6506344 6508528 6508991 6509276 6509324 6509337 6510326 6510658 6511018 6512545 6512734 6513244 6518355 6518536 6518537 6518540 6522162 6522946 6523067 6523940 6524088 6524236 6524353 6524372 6525124 6525231 6525308 6525738 6525790 6525827 6526067 6526092 6527110 6527234 6527592 6528080 6528172 6528212 6528782 6529036 6529856 6529986 6530114 6530288 6530345 6530449 6530529 6530539 6531569 6532877 6533274 6534457 6535290 6535674 6536496 6536926 6537437 6538762 6538900 6538901 6539201 6542294 6393349 1000001928 1000002048 1000002235 1000002511 1000002515 6394720 1000003776 6390075 6391635 1000003982 6384876 1000004846 1000005324 1000005434 1000007142 1000001931 1000007815 1000006604 1000007981 6393248 1000005225 1000001939 6392810 1000009327 1000008858 1000009973 1000009974 1000009978 1000005503 1000010294 1000010224 1000011008 1000007875 1000008219 1000013164 1000009753 1000012923 1000010500 1000014534 1000014691 1000014724 1000015167 1000014039 1000015285 1000014868 1000015628 1000009862 1000015968 1000015921 1000014980 1000017583 1000017589 1000017591 1000017714 1000017718 1000018953 1000018954 1000018955 1000018956 1000018957 1000018958 1000018959 1000018960 1000018961 1000019056 1000019057 1000019058 1000019354 1000009571 1000019563 1000020472 1000010952 1000019063 1000020852 1000020861 1000021295 1000021304 1000021324 1000015973 1000021498 1000016253 1000022340 1000022971 1000022983 1000022984 1000023002 1000023004 1000017690 1000013404 1000026649 1000027347 1000027399 1000027400 1000027405 1000027408 1000027409 1000027411 1000027414 1000027418 1000027419 1000027420 1000027451 1000027453 1000027455 1000027483 1000027485 1000027487 1000027490 1000027493 1000027501 1000027503 1000027506 1000027147 1000012381 1000029118 1000029134 1000029135 1000029136 1000029222 1000029225 1000029229 1000029982 1000030143 1000030145 1000030146 1000030383 1000030389 1000030391 1000030393 1000030147 1000015990 1000004799 1000032610 1000033803 1000033804 1000033809 1000034016 1000034017 1000033814 1000034055 1000014890 1000034256 1000034130 1000035641 1000035643 1000035650 1000035651 1000035652 1000035653 1000035654 1000035655 1000035656 1000035657 1000035658 1000035664 1000035665 1000035666 1000019761 1000036127 1000036296 1000005828 1000036440 1000036445 1000035667 1000034258 1000039200 1000040079 1000040080 1000040081 1000040082 1000040084 1000040088 1000040097 1000040098 1000040100 1000040108 1000040109 1000040129 1000040267 1000040966 1000040985 1000040991 1000040992 1000041043 1000041275 1000041278 1000041291 1000041292 1000041293 1000041301 1000041304 1000041305 1000041309 1000041317 1000041321 1000041322 1000041323 1000041324 1000041327 1000041337 1000041340 1000041456 1000042033 1000042044 1000042055 1000042056 1000042061 1000042062 1000042077 1000042080 1000003310 1000042850 1000043110 1000043133 1000043136 1000043245 1000043246 1000043259 1000043262 1000043264 1000043265 1000043334 1000043336 1000043349 1000043350 1000043351 1000043352 1000043355 1000043356 1000043373 1000043374 1000043375 1000043376 1000043390 1000043400 1000043426 1000043427 1000043428 1000043429 1000043436 1000043437 1000043438 1000043443 1000043444 1000043724 1000043793 1000043794 1000005141 1000043831 1000022341 1000043977 1000044903 1000044904 1000044955 1000044956 1000045987 1000045988 1000046023 1000046047 1000046105 1000046109 1000046131 1000046358 1000046764 1000046781 1000046841 1000046861 1000044508 1000036126 1000047378 1000047379 1000047386 1000047387 1000047606 1000047442 1000047875 1000047928 1000041444 1000047714 1000048381 1000048172 1000048478 1000048708 1000041254 1000048893 1000043346 1000041420 1000048771 1000048586 1000044958 1000049629 1000049849 1000050502 1000050585 1000050725 1000051019 1000051026 1000048665 1000051908 1000051956 1000051957 1000051961 1000051914 1000024035 1000052223 1000052554 1000052556 1000052456 1000052992 1000037262 1000010043 1000053514 1000053515 1000052702 1000053922 1000053926 1000054225 1000054324 1000052827 1000054466 1000054729 1000054554 1000048597 1000055131 1000055574 1000055579 1000049980 1000056133 1000056282 1000056283 1000056380 1000056132 1000056572 1000056269 1000055910 1000049068 1000056905 1000055411 1000057163 1000056659 1000055356 1000057464 1000057562 1000058030 1000058202 1000059864 1000060714 1000060918 1000061389 1000061889 1000029230 1000062265 1000062475 1000062633 1000062634 1000047415 1000052259 1000063105 1000063204 1000064003 1000064192 1000064709 1000065240 1000065852 1000065947 1000066203 1000065269 634 ] |
|
32.21 ms (2.08%) |
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:
[
"10391-objets-a-decorer-couleur-n-c-2013-o'color"
]
|
|
3.70 ms (0.24%) |
19 |
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:
[
634
]
|
|
3.59 ms (0.23%) |
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
]
|
|
0.70 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:
[ 84 396 397 398 399 400 401 402 400 634 ] |
|
0.62 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:
[
"10391-objets-a-decorer-couleur-n-c-2013-o'color"
]
|
|
0.41 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:
[
"10391-objets-a-decorer-couleur-n-c-2013-o'color"
]
|
|
0.38 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:
[ 634 1 ] |
|
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:
[
634
]
|
|
0.27 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.26 ms (0.02%) |
1 |
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"
]
|
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 | 746 |
| App\Entity\Customer\Customer | 233 |
| App\Entity\Delivery\Delivery | 182 |
| App\Entity\User\User | 175 |
| App\Entity\Catalog\ProductCatalog | 94 |
| App\Entity\Catalog\CustomerCatalog | 94 |
| App\Entity\Product\Market | 49 |
| App\Entity\Internal\Commercial | 29 |
| App\Entity\Pricing\Price | 28 |
| App\Entity\Product\ProductPrice | 24 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Product | 19 |
| App\Entity\Product\Characteristic | 10 |
| App\Entity\Product\CharacteristicLabel | 10 |
| App\Entity\Delivery\DeliveryCost | 6 |
| App\Entity\Internal\Society | 4 |
| App\Entity\Internal\Parameter | 1 |