Query Metrics
49
Database Queries
12
Different statements
1021.24 ms
Query time
0
Invalid entities
1618
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
506.43 ms (49.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:
[ 194771 "2025-04-12 15:01:20" ] |
|
456.20 ms (44.67%) |
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:
[ 6385963 6386435 6387290 6386706 6383823 6388480 6388519 6388125 6388023 6389550 6390524 6390534 6390627 6390674 6391266 6390106 6391885 6392093 6392395 6392094 6388629 6394343 6394448 6394683 6394688 6395309 6395482 6395689 6396236 6398317 6398734 6398848 6399741 6400270 6400598 6400767 6401570 6401616 6402565 6404608 6405128 6405485 6406338 6406661 6407146 6407552 6408529 6410127 6411369 6411512 6412050 6412061 6412554 6413122 6414998 6415041 6416140 6416302 6416390 6416476 6416829 6416898 6416970 6417319 6417444 6417628 6418057 6418536 6418893 6419146 6419159 6419272 6419296 6419319 6419343 6419381 6419391 6419414 6419485 6419571 6419916 6420611 6420628 6420715 6421760 6421796 6421909 6422045 6422637 6422651 6422694 6422848 6423816 6425186 6426837 6427285 6429602 6429633 6429653 6429687 6431496 6432175 6432339 6432346 6434284 6434606 6434662 6434797 6434816 6435207 6435351 6436027 6437044 6437070 6437113 6438935 6439743 6439949 6440835 6441553 6441958 6443053 6443397 6443421 6443572 6444364 6444372 6444759 6444811 6444857 6445330 6445669 6445777 6446743 6446944 6447090 6447242 6447577 6447677 6449439 6449481 6449703 6449727 6449777 6451112 6451290 6451564 6451572 6451666 6451703 6451961 6452364 6452531 6452588 6452612 6453556 6453559 6454620 6455133 6455263 6455317 6455347 6455423 6455636 6455686 6455754 6455762 6455801 6455805 6455806 6455820 6455842 6455995 6456003 6456106 6456232 6456264 6456480 6456673 6456954 6457246 6457885 6458366 6459212 6459250 6459953 6461416 6462224 6462569 6462973 6462994 6464026 6464054 6464834 6464845 6466358 6466690 6468938 6468968 6468999 6469590 6469668 6469695 6469732 6470177 6470228 6471038 6472290 6472950 6474646 6474656 6475466 6476872 6477617 6480635 6480732 6481090 6481848 6482744 6482984 6483562 6484126 6484679 6484928 6485573 6486127 6486761 6488528 6489024 6489073 6490190 6492235 6493093 6494427 6494680 6495599 6496196 6496425 6496773 6496775 6496776 6497486 6498123 6498409 6498425 6498568 6498598 6498819 6498839 6498938 6498955 6499128 6499137 6499275 6499507 6499546 6499670 6500258 6500517 6501456 6501517 6501530 6501536 6501548 6501607 6501838 6502162 6502192 6502275 6502360 6502464 6502618 6502722 6502757 6502817 6502853 6503255 6503485 6503983 6504009 6504893 6505385 6505861 6506406 6507139 6507204 6507490 6509603 6509711 6511247 6511451 6512781 6512818 6515419 6518036 6522005 6522906 6523928 6524443 6524838 6524956 6525309 6525412 6525450 6525820 6525939 6525971 6526047 6526436 6526474 6526563 6526912 6527177 6527402 6528014 6528477 6528608 6528770 6528778 6528818 6528913 6528928 6529164 6529415 6529708 6529837 6529995 6530029 6530056 6530102 6530279 6530363 6530466 6532650 6532760 6532911 6533131 6538494 6540801 6541953 6364544 1000000890 1000000930 1000001712 1000002039 1000002182 1000000976 1000004183 6390715 6389706 6390109 1000007011 1000007261 1000007262 1000003437 1000007717 1000002162 1000008786 1000009034 1000008922 1000009327 1000009427 1000009627 1000009984 1000010509 1000010556 1000009248 1000011801 1000011884 1000009607 6391605 1000012321 1000012335 1000008559 6392545 1000012620 1000012679 1000012765 1000013100 1000013102 1000013164 1000013174 1000013563 1000008555 1000005021 1000015788 1000012235 1000016672 1000016681 1000007537 1000011837 1000017686 1000017687 1000017688 1000017719 1000017752 1000017754 1000019180 1000019183 1000019968 1000019980 1000019188 1000021531 1000022070 1000022073 1000022074 1000022075 1000022076 1000022077 1000022078 1000022083 1000022084 1000022085 1000022127 1000022129 1000022139 1000022162 1000022191 1000022247 1000022363 1000022366 1000022367 1000022383 1000022384 1000012938 1000022858 1000022859 1000020095 1000017143 1000023030 1000024900 1000025026 1000025170 1000012700 1000025728 1000025921 1000025925 1000025927 1000025954 1000025964 1000025989 6385936 1000026678 1000026905 1000022192 1000026916 1000026917 1000026918 1000026920 1000026922 1000026924 1000026939 1000026953 1000026958 1000026959 1000026960 1000026987 1000016964 1000027100 1000016744 1000012381 1000016471 1000025812 1000030229 1000030411 1000030412 1000022019 1000023328 1000002606 1000032252 1000032281 1000032308 1000032309 1000032310 1000032322 1000032323 1000032336 1000032370 1000032375 1000032378 1000032443 1000032445 1000032501 1000032521 1000022069 1000025999 1000021035 1000034396 1000034399 1000034404 1000034406 1000034408 1000034419 1000034424 1000034425 1000034426 1000034428 1000034429 1000034431 1000030359 1000035142 1000035294 1000035366 1000035406 1000035452 1000035504 1000035506 1000028580 1000035515 1000035518 1000015433 1000036497 1000023726 1000037319 1000037320 1000037322 1000037403 1000037407 1000039681 1000039693 1000039696 1000039699 1000039700 1000039710 1000039714 1000039716 1000039719 1000039720 1000039721 1000039718 1000040066 1000040067 1000040069 1000040070 1000040071 1000040072 1000040073 1000040074 1000040077 1000041074 1000041075 1000041118 1000041314 1000041168 1000036231 1000040712 1000037933 1000016071 1000021976 1000043094 1000043421 1000043422 1000043423 1000043425 1000043430 1000043431 1000043433 1000043435 1000043439 1000043979 1000043985 1000043991 1000043992 1000043993 1000044317 1000044319 1000044324 1000044332 1000044341 1000044342 1000044362 1000044364 1000044366 1000044355 1000044485 1000044512 1000044513 1000044543 1000044551 1000045040 1000045043 1000020082 1000046114 1000046115 1000046148 1000046194 1000046197 1000046201 1000046208 1000046219 1000009336 1000046838 1000047893 1000048465 1000048508 1000048357 1000048908 1000049123 1000049124 1000049224 1000049530 1000050009 1000050547 1000050568 1000050664 1000050001 1000050955 1000048190 1000050780 1000050321 1000051686 1000051739 1000051741 1000051750 1000051818 1000051884 1000052102 1000052823 1000052824 1000010492 1000052837 1000052852 1000052940 1000053322 1000053466 1000053530 1000054401 1000054579 1000053425 1000052007 1000054996 1000055183 1000054596 1000055263 1000055407 1000055408 1000055478 1000054831 1000056156 1000056307 1000056443 1000054260 1000056444 1000056743 1000057034 1000057151 1000057212 1000057744 1000057955 1000057961 1000057963 1000057964 1000057965 1000057966 1000057991 1000058171 1000057967 1000050622 1000059479 1000059735 1000060737 1000060986 1000060987 1000057738 1000057868 1000064824 1000065630 1000065714 1000066093 1000065465 1000064675 194771 ] |
|
42.99 ms (4.21%) |
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:
[
"25825-crayons-de-couleur-couleur-n-c-25825"
]
|
|
6.86 ms (0.67%) |
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:
[
194771
]
|
|
5.37 ms (0.53%) |
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.71 ms (0.07%) |
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 389 194771 ] |
|
0.68 ms (0.07%) |
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.64 ms (0.06%) |
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:
[
"25825-crayons-de-couleur-couleur-n-c-25825"
]
|
|
0.39 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:
[
"25825-crayons-de-couleur-couleur-n-c-25825"
]
|
|
0.39 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:
[ 194771 1 ] |
|
0.29 ms (0.03%) |
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"
]
|
|
0.28 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:
[
194771
]
|
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 | 671 |
| App\Entity\Customer\Customer | 233 |
| App\Entity\User\User | 164 |
| App\Entity\Delivery\Delivery | 155 |
| App\Entity\Catalog\ProductCatalog | 98 |
| App\Entity\Catalog\CustomerCatalog | 98 |
| App\Entity\Product\Market | 45 |
| App\Entity\Pricing\Price | 28 |
| App\Entity\Internal\Commercial | 25 |
| App\Entity\Product\ProductPrice | 24 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 12 |
| App\Entity\Product\CharacteristicLabel | 12 |
| App\Entity\Delivery\DeliveryCost | 6 |
| App\Entity\Internal\Society | 4 |
| App\Entity\Internal\Parameter | 1 |