Query Metrics
49
Database Queries
12
Different statements
964.76 ms
Query time
0
Invalid entities
1703
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
507.98 ms (52.65%) |
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:
[ 6386706 6386917 6388163 6388480 6389049 6388023 6391293 6391885 6387952 6388986 6393413 6394259 6394451 6395407 6400466 6402172 6406012 6410542 6412554 6412694 6413043 6413625 6413836 6414241 6414378 6414609 6415037 6415088 6415489 6415820 6415848 6415977 6416027 6416941 6417239 6418171 6419171 6419319 6419414 6419559 6419915 6420934 6421368 6421650 6421884 6422069 6422565 6422670 6422848 6422952 6423648 6423701 6424246 6425118 6425768 6426204 6426349 6427165 6427319 6427874 6428177 6428474 6428896 6429908 6430798 6430950 6431198 6431211 6432195 6434049 6434429 6434550 6434875 6434922 6434985 6435242 6435345 6435728 6435935 6436018 6437033 6437616 6438089 6438287 6438538 6438870 6438986 6439860 6440903 6443026 6443282 6443644 6443952 6444102 6444133 6444231 6444275 6444302 6444333 6444356 6444607 6445186 6445346 6445521 6445601 6446089 6446095 6446099 6446128 6446255 6446430 6446449 6446475 6446690 6447011 6447241 6447256 6447399 6447726 6447788 6448563 6448753 6449013 6449797 6449834 6449955 6450150 6450157 6450168 6450180 6450252 6450611 6450665 6450877 6450880 6451213 6451239 6451247 6451418 6451906 6451915 6452352 6452420 6452543 6453322 6453425 6453471 6453482 6453549 6453869 6453932 6454010 6454127 6454533 6454628 6454632 6454667 6454728 6454826 6455063 6455126 6455131 6455154 6455267 6455317 6455318 6455322 6455409 6455469 6455532 6455557 6455576 6455598 6455867 6456106 6457044 6457256 6457258 6457261 6457265 6457269 6458546 6459880 6459930 6461516 6461852 6462227 6462514 6462994 6465645 6466386 6466438 6466528 6468043 6468056 6469386 6469590 6470240 6470349 6470567 6471178 6471189 6472309 6472531 6472733 6473050 6473111 6474517 6474734 6475247 6475554 6475674 6476525 6476539 6476669 6477120 6477902 6480490 6480761 6481141 6481937 6482822 6483191 6483219 6483720 6484776 6485150 6485266 6486444 6489068 6490013 6490620 6490728 6490754 6491469 6491986 6492215 6493002 6493705 6494314 6494321 6495318 6495428 6496906 6496959 6497117 6497209 6497374 6497559 6497574 6497705 6497729 6497759 6497795 6498027 6498041 6498052 6498241 6498513 6498573 6498598 6498878 6498912 6498917 6498960 6498968 6499265 6499280 6499334 6500309 6500714 6500972 6501438 6501488 6501553 6501560 6501731 6501972 6501975 6501978 6501982 6501987 6502006 6502122 6502373 6502403 6502572 6502740 6503120 6504255 6505398 6506004 6507071 6507109 6507298 6508976 6509198 6509270 6509434 6509623 6510339 6510412 6510516 6512300 6512711 6519188 6521095 6521108 6522134 6522187 6522247 6523944 6524141 6524274 6524314 6524333 6524425 6524846 6524867 6524958 6524959 6525065 6525246 6525293 6525305 6525306 6525309 6525350 6525416 6526059 6526200 6526213 6526224 6526488 6527286 6528104 6528105 6528590 6528753 6528766 6528770 6528952 6529244 6529768 6529855 6529871 6529986 6530078 6530224 6530271 6530525 6531328 6532925 6533205 6533400 6534448 6535840 6535848 6537190 6537559 6537583 6537883 6538219 6539456 6539676 6393298 1000000977 1000002067 1000002269 1000002639 1000005945 1000005946 1000005947 1000006105 1000006977 1000007031 1000008922 1000008259 1000006281 1000009246 1000009627 1000005944 1000008224 1000002150 1000010066 1000010183 1000010509 1000010471 1000009241 1000008124 1000010996 1000011932 1000011949 1000012425 1000012476 1000012508 1000012929 1000013100 1000013102 6367546 1000006085 1000008349 1000012717 1000012704 1000015412 1000015424 1000015555 1000015949 1000010203 6378345 1000016437 1000016507 1000017027 1000009771 1000015951 1000016454 1000017113 1000016336 1000017932 1000017933 1000017937 1000018472 1000018531 1000013952 1000018833 1000018836 1000018838 1000018965 1000019246 1000019450 1000002286 1000019643 1000019667 1000019886 1000019887 1000020222 1000020223 1000020225 1000020226 1000020233 1000020281 1000020472 1000020852 1000020854 1000020861 1000020867 1000016529 1000021295 1000021806 1000021807 1000021813 1000021814 1000021817 1000021881 1000021885 1000021887 1000021972 1000003873 1000022185 1000021890 1000023318 1000023769 1000019779 1000024543 1000024544 1000024547 1000024549 1000024624 1000024626 1000017879 1000025497 1000025500 1000025508 1000016767 1000026132 1000026133 1000026135 1000026194 1000026571 1000020251 1000022857 1000026988 1000026991 1000027009 1000027012 1000027014 1000027015 1000027020 1000027158 1000027184 1000027201 1000021125 1000015126 1000022147 1000029720 1000024630 1000027016 1000029869 1000021824 1000030247 1000030365 1000030415 1000030442 1000024088 1000030906 1000031534 1000031549 1000031550 1000016954 1000031994 1000032360 1000026136 1000016571 1000033223 1000026317 1000026226 1000034125 1000034128 1000034177 1000034179 1000034181 1000034182 1000034183 1000034184 1000034192 1000034195 1000033657 1000001795 1000036299 1000036349 1000035153 1000036940 1000036941 1000036531 1000037758 1000037759 1000037760 1000037761 1000037764 1000037769 1000037781 1000038408 1000038434 1000038442 1000038446 1000038784 1000038798 1000038804 1000038807 1000038836 1000039021 1000039024 1000039026 1000039081 1000039082 1000039286 1000040207 1000040531 1000040833 1000040834 1000040836 1000040863 1000040886 1000040889 1000015789 1000041563 1000041569 1000041571 1000041572 1000025165 1000030908 1000041856 1000041858 1000041859 1000041860 1000041861 1000041862 1000041863 1000041865 1000041866 1000041869 1000041876 1000041877 1000041878 1000041880 1000041881 1000041882 1000041883 1000041885 1000041894 1000041895 1000041896 1000043229 1000043231 1000043233 1000043234 1000043235 1000043236 1000025829 1000043823 1000043864 1000016946 1000037918 1000036517 1000046003 1000041412 1000047578 1000047587 1000047750 1000039723 1000048158 1000048260 1000021960 1000048738 1000048806 1000046093 1000048017 1000046549 1000031997 1000042321 1000049868 1000048968 1000043301 1000050415 1000049151 1000050493 1000050583 1000050647 1000050649 1000050955 1000051217 1000051317 1000051377 1000051067 1000048910 1000051663 1000051705 1000051778 1000051818 1000048886 1000051895 1000049385 1000019952 1000036990 1000052173 1000052647 1000052652 1000052901 1000052861 1000053081 1000052569 1000053132 1000052712 1000053386 1000053716 1000052077 1000053684 1000054985 1000055143 1000055145 1000055327 1000050252 1000039083 1000055859 1000055860 1000055861 1000056180 1000056612 1000054023 1000057508 1000057509 1000054640 1000056712 1000059407 1000059919 1000060074 1000054939 1000062243 1000062628 1000062619 1000063703 1000053876 1000064255 709 ] |
|
391.56 ms (40.59%) |
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:
[ 709 "2025-04-13 04:26:17" ] |
|
54.15 ms (5.61%) |
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:
[
"10541-cahiers-speciaux-couleur-hamelin-100104473"
]
|
|
4.53 ms (0.47%) |
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:
[
709
]
|
|
3.49 ms (0.36%) |
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.73 ms (0.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 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:
[ 41 189 190 191 192 193 194 195 192 709 ] |
|
0.69 ms (0.07%) |
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:
[
"10541-cahiers-speciaux-couleur-hamelin-100104473"
]
|
|
0.43 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:
[ 709 1 ] |
|
0.37 ms (0.04%) |
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:
[
"10541-cahiers-speciaux-couleur-hamelin-100104473"
]
|
|
0.31 ms (0.03%) |
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:
[
709
]
|
|
0.29 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.22 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 | 683 |
| App\Entity\Customer\Customer | 221 |
| App\Entity\User\User | 165 |
| App\Entity\Delivery\Delivery | 150 |
| App\Entity\Catalog\ProductCatalog | 141 |
| App\Entity\Catalog\CustomerCatalog | 141 |
| App\Entity\Product\Market | 43 |
| App\Entity\Pricing\Price | 27 |
| App\Entity\Product\ProductPrice | 25 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Internal\Commercial | 21 |
| App\Entity\Product\Characteristic | 18 |
| App\Entity\Product\CharacteristicLabel | 17 |
| App\Entity\Internal\Society | 4 |
| App\Entity\Delivery\DeliveryCost | 4 |
| App\Entity\Internal\Parameter | 1 |