Query Metrics
47
Database Queries
21
Different statements
3453.44 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 117.01 ms |
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:
[
"43010-dessin-et-accessoire-transparent-n-c-43010-excel"
]
|
2 | 0.56 ms |
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:
[
"43010-dessin-et-accessoire-transparent-n-c-43010-excel"
]
|
3 | 0.37 ms |
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:
[
"43010-dessin-et-accessoire-transparent-n-c-43010-excel"
]
|
4 | 0.42 ms |
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:
[ 9848 1 ] |
5 | 0.65 ms |
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:
[ 44 210 211 212 213 214 215 210 9848 ] |
6 | 0.23 ms |
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"
]
|
7 | 2258.68 ms |
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:
[ 9848 "2025-02-12 11:07:21" ] |
8 | 1059.05 ms |
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:
[ 6325240 6337750 6337508 6322765 6338857 6339724 6340021 6340081 6340289 6340964 6331303 6341427 6341550 6341025 6342943 6343030 6321671 6343739 6343992 6344309 6344449 6324303 6345333 6346834 6347059 6347349 6347350 6348553 6348938 6349035 6349036 6349379 6349390 6349552 6349728 6346094 6351374 6352821 6354089 6355194 6355081 6361299 6362275 6362649 6362930 6365209 6365718 6365948 6366420 6369089 6369345 6369371 6369857 6370241 6371268 6372063 6372090 6372363 6372564 6377053 6378063 6378369 6378415 6378767 6374767 6380245 6377052 6380866 6381816 6382598 6366232 6384498 6384609 6382373 6366688 6376830 6386759 6385142 6387230 6387305 6387693 6387937 6388128 6388134 6388398 6388558 6388639 6388962 6390184 6390988 6343284 6390607 6391474 6392012 6392109 6390889 6386796 6388500 6393075 6393283 6393520 6393343 6393882 6394096 6394109 6394022 6394189 6387546 6394448 6391774 6395302 6395733 6396199 6396244 6398227 6398537 6398574 6398611 6398733 6398847 6400034 6400035 6400154 6400222 6400270 6400587 6400727 6400742 6400838 6400989 6401652 6403164 6403303 6403928 6405417 6405975 6406388 6406423 6406509 6407083 6407499 6407505 6408050 6408448 6408769 6408812 6409206 6410073 6409213 6410426 6410609 6410859 6411046 6411213 6411344 6411702 6411903 6412166 6412435 6412643 6412646 6412665 6412669 6412858 6413610 6413754 6413796 6413886 6414739 6414750 6415089 6415460 6415714 6415854 6416071 6416116 6416219 6416269 6416325 6416328 6416329 6416471 6416809 6416846 6416848 6416932 6416958 6416959 6417005 6417109 6417315 6417474 6417579 6417704 6417886 6418527 6418805 6418843 6418942 6419024 6419133 6419146 6419315 6419354 6419355 6419442 6419576 6419885 6419886 6420228 6420413 6420645 6420883 6421392 6421601 6422078 6422159 6422727 6422798 6422928 6423089 6423251 6423996 6424413 6425405 6426132 6426172 6426199 6426324 6426353 6426615 6426793 6426978 6426983 6426993 6427189 6427192 6427214 6427329 6427460 6427549 6427678 6427984 6428247 6428638 6428908 6429041 6429090 6429532 6429577 6429615 6429626 6429670 6429786 6429805 6429887 6430292 6430363 6430521 6430804 6430924 6430938 6431021 6431184 6431401 6431444 6431524 6431602 6431714 6431859 6431903 6431978 6432069 6432090 6432194 6432232 6432272 6432322 6433457 6433539 6433544 6433762 6433779 6433921 6434195 6434626 6434671 6434688 6434754 6434789 6434790 6434891 6434852 6434952 6435101 6435351 6435496 6435466 6435559 6435919 6435928 6436001 6436002 6436072 6436278 6436710 6437148 6437222 6437309 6437748 6437825 6437822 6437986 6437991 6438063 6438094 6438103 6438124 6438583 6438626 6438645 6438784 6438882 6439201 6439628 6439687 6439759 6439939 6439937 6440015 6440183 6440211 6440278 6440544 6441127 6441212 6441243 6441410 6441873 6442109 6442167 6442182 6442299 6442573 6443132 6443241 6443246 6443362 6443402 6443685 6444783 6444899 6444958 6445001 6445352 6445560 6445601 6445803 6446038 6446051 6446054 6446127 6446150 6446178 6446244 6446339 6446342 6446521 6446551 6446577 6446641 6446700 6446702 6446739 6446779 6446821 6446914 6446956 6446984 6447057 6447124 6447368 6447427 6447477 6447674 6448207 6448241 6448563 6448617 6448697 6448785 6448951 6449047 6449332 6449495 6449722 6449728 6449763 6449879 6449897 6450013 6450153 6450155 6450172 6450174 6450180 6450183 6450186 6450191 6450195 6450253 6450365 6450440 6450441 6450482 6450505 6450614 6450655 6450833 6450856 6450887 6450921 6450972 6450993 6450998 6451002 6451010 6451025 6451135 6451199 6451220 6451247 6451338 6451362 6451371 6451439 6451569 6451573 6451574 6451593 6451649 6451667 6451794 6451802 6451907 6452004 6452010 6452042 6452218 6452247 6452253 6452301 6452350 6452415 6452553 6452555 6452570 6452587 6452590 6452611 6452830 6453125 6453140 6453317 6453471 6453504 6453516 6453551 6453556 6453591 6453732 6453913 6454514 6454524 6454563 6454582 6454591 6454608 6454610 6454625 6454627 6454631 6454745 6454761 6454807 6454842 6454852 6454899 6454926 6454930 6454985 6455073 6455210 6455237 6455257 6455307 6455308 6455334 6455347 6455388 6455417 6455423 6455473 6455501 6455578 6455584 6455593 6455723 6455826 6455839 6455841 6455842 6455867 6455966 6456070 6456261 6456511 6456536 6457009 6457062 6457205 6457245 6457417 6457441 6457513 6457516 6457526 6457775 6457799 6457882 6457988 6458194 6458418 6458559 6459106 6459109 6459162 6459200 6459224 6459372 6459585 6459628 6459642 6459877 6459953 6460000 6460014 6460274 6460358 6460990 6461026 6461070 6461296 6461416 6461439 6461450 6461568 6461574 6461613 6461621 6461655 6461675 6461746 6461914 6462118 6462540 6462680 6462695 6462717 6462893 6462905 6462941 6463025 6463232 6463233 6463516 6463852 6464215 6464309 6464350 6464413 6464535 6464767 6464801 6465243 6465298 6465369 6465636 6465683 6465814 6466049 6466337 6466368 6466438 6466636 6466755 6467374 6468042 6468545 6468695 6469062 1000000900 6389415 1000000947 1000001349 6381528 1000002699 1000002864 1000003037 1000003856 1000003186 1000003892 6392374 1000004292 1000004300 1000004308 1000004310 1000004490 1000004584 1000004681 1000004683 1000002109 1000002528 1000002019 1000004569 1000002186 1000001832 1000005339 1000005343 1000006027 1000006076 1000006148 6392776 1000008019 1000004700 1000008119 1000004521 1000008576 1000008734 1000001354 1000008404 1000001743 1000009304 1000007852 1000009747 1000009852 1000009945 1000009808 6391122 1000001857 1000007890 1000010379 1000009717 1000011034 1000011830 1000004768 1000009252 1000011931 1000010874 1000012128 1000012228 1000012323 1000009564 1000012450 1000002097 1000012676 1000009930 1000013267 1000013416 1000012685 1000012348 1000012142 1000010622 1000013504 1000012385 1000008795 1000013814 1000012796 1000013798 1000009448 1000011096 1000014596 1000014687 1000006473 1000010388 1000014880 1000012293 1000005543 1000015081 1000014283 1000012619 1000012648 1000015511 1000009775 1000015476 1000014894 1000013193 1000016166 1000016168 1000016169 1000016234 1000011054 1000016258 1000016263 1000016331 1000011053 1000016358 1000016410 1000014387 1000016511 1000016630 1000016097 1000016953 1000017168 1000017102 1000016791 1000015983 1000012415 1000017020 1000016175 1000011087 1000017169 1000016533 1000017526 1000017544 1000017579 1000017587 1000017681 1000017694 1000017695 1000017697 1000017705 1000017706 1000017715 1000017891 1000017892 1000017897 1000017898 1000017904 1000017905 1000017906 1000017907 1000017908 1000017909 1000017910 1000017911 1000017912 1000017913 1000017914 1000017915 1000017916 1000017917 1000017918 1000017919 1000017920 1000017921 1000017922 1000017923 1000017924 1000017925 1000017926 1000017931 1000017953 1000017954 1000017955 1000017956 1000017960 1000017961 1000017962 1000017963 1000018045 1000018039 1000018052 1000018053 1000018054 1000018134 1000018137 1000018138 1000018139 1000018143 1000018144 1000018146 1000018345 1000018452 1000018473 1000018474 1000018504 1000014881 1000011989 1000018869 1000018870 1000018871 1000018872 1000018879 1000018891 1000018906 1000018911 1000018919 1000018920 1000018926 1000018994 1000018996 1000019055 1000019065 1000019083 1000019100 1000019104 1000019115 1000019136 1000019186 1000019187 1000019277 1000019281 1000019282 1000019299 1000019302 1000019305 1000019308 1000019318 1000019379 1000019380 1000019388 1000017743 1000019393 1000019397 1000019398 1000019400 1000017704 1000019415 1000012178 1000019442 1000019481 1000019478 1000019499 1000019501 1000019503 1000019511 1000019514 1000019520 1000019521 1000019523 1000019589 1000019612 1000019804 1000016411 1000019953 1000019956 1000019957 1000019958 1000019960 1000020014 1000020017 1000020103 1000020037 1000020219 1000020241 1000020242 1000020247 1000009111 1000020296 1000020300 1000020372 1000018529 1000016359 1000015402 1000020439 1000016959 1000014033 1000020564 1000016320 1000018731 1000020240 1000021002 1000021157 1000021158 1000021220 1000013467 1000012314 1000021277 1000021290 1000020562 1000015487 1000021693 1000019095 1000000901 1000022116 1000018750 1000022166 1000022167 1000013196 1000022255 1000022254 1000019101 1000014079 1000019091 1000021805 1000021118 1000012612 1000016064 1000022682 1000022690 1000013474 1000009774 1000012677 1000023425 1000023763 1000025170 1000025451 1000021695 1000017957 1000025836 1000025841 1000025843 1000025846 1000025856 1000026178 1000026408 1000026482 1000026483 1000026501 1000022522 1000009675 1000013840 1000014705 1000016227 1000026484 1000022575 1000027056 1000021567 1000025453 1000027123 1000012540 1000027253 1000027254 1000027285 1000027370 1000027399 1000027400 1000027405 1000027408 1000027409 1000027411 1000027414 1000027553 1000013771 1000027764 1000027771 1000027772 1000027777 1000028381 1000028290 1000016632 1000017713 1000028960 1000028962 1000029098 1000020632 1000029566 1000029579 1000029589 1000029594 1000029635 1000019638 1000021971 1000023426 1000017889 1000020134 1000028718 1000030015 1000030055 1000030066 1000030216 1000030227 1000030765 1000030786 1000030802 1000030824 1000030825 1000030826 1000030827 1000030828 1000010765 1000028296 1000028382 1000031729 1000031730 1000028476 1000031936 1000021691 1000032030 1000032244 1000032251 1000032254 1000032260 1000032264 1000032296 1000032298 1000013876 1000032343 1000029638 1000032633 1000032801 1000033256 1000033324 1000033327 1000033335 1000033565 1000033566 1000033567 1000033568 1000013644 1000031724 1000034047 1000034049 1000034119 1000034129 1000021444 1000019123 1000025885 1000013708 1000032524 1000034654 1000034657 1000034660 1000034662 1000034724 1000026785 1000034787 1000031774 1000034801 1000034963 1000035272 1000035460 1000035463 1000035499 1000035500 1000035505 1000033569 1000035669 1000035670 1000030590 1000035711 1000035716 1000035536 1000036454 1000036455 1000036459 1000036460 1000036466 1000036468 1000036469 1000036470 1000036477 1000036478 1000036479 1000036483 1000036489 1000036547 1000036484 1000036564 1000036565 1000036566 1000036567 1000036568 1000036578 1000036581 1000036582 1000030223 1000035248 1000036822 1000036823 1000012245 1000037549 1000037551 1000037557 1000037814 1000037826 1000037827 1000037893 1000037894 1000037895 1000037915 1000037921 1000014485 1000038631 1000038794 1000016664 1000040045 1000040047 1000040048 1000040052 1000034830 1000029787 1000040722 1000040795 1000040797 1000034788 1000040948 1000040967 1000040968 1000040969 1000040971 1000041428 1000041520 1000041556 1000041557 1000041558 1000041560 1000041561 1000041570 1000041663 1000041664 1000041665 1000041666 1000041738 1000041764 1000041929 1000041933 1000041950 1000041953 1000041996 1000042380 1000042486 1000042497 1000042528 1000042484 1000042686 1000027525 1000042990 1000043467 1000043468 1000042523 1000043657 1000043673 1000043826 1000043827 1000043828 1000043834 1000043867 1000043868 1000043876 1000022214 1000043887 1000040973 1000044131 1000044134 1000044137 1000044146 1000044223 1000044227 1000031882 1000041745 1000043666 1000044739 1000044755 1000044762 1000044763 1000044767 1000044815 1000044825 1000044839 1000016447 1000044846 1000044865 1000044876 1000044882 1000044884 1000044943 1000044753 1000045359 1000045366 1000045607 1000045699 1000035464 1000045722 1000045723 1000045726 1000045815 1000045821 1000045859 1000045860 1000045999 1000046000 1000046014 1000046028 1000046060 1000046114 1000046115 1000046122 1000046148 1000046194 1000046197 1000046201 1000046208 1000046210 1000046216 1000046219 1000046254 1000046276 1000046337 1000046370 1000046371 1000046372 1000046373 1000046392 1000046417 1000046837 1000043907 1000046916 1000046917 1000046934 1000047138 1000047471 1000047473 1000047474 1000047277 1000043611 1000046255 1000047651 1000032326 1000047789 1000047769 1000047825 1000047490 1000042625 1000028619 1000046419 1000047964 1000047965 1000047980 1000047984 1000048032 1000048111 1000048112 1000048113 1000048119 1000048155 1000015177 1000048199 1000043088 1000048217 1000048218 1000044932 1000048320 1000048323 1000048377 1000048401 1000048420 1000045005 1000048346 1000028254 1000048552 1000048568 1000048602 1000048623 1000025527 1000048347 1000048248 1000048083 1000035809 1000048834 1000048339 1000044886 1000025427 1000048983 1000037931 1000024541 1000048282 1000049208 1000049217 1000049237 1000048958 1000049321 1000049261 1000009778 1000042895 1000049485 1000049547 1000049187 1000049597 1000049634 1000049594 1000049807 1000049838 1000048913 1000050028 1000049902 1000050076 1000050082 1000050091 1000050115 1000050116 1000050182 1000050196 1000047731 1000050354 1000050355 1000050120 1000049151 1000050493 1000050512 1000032442 1000048607 1000049234 1000050370 1000050604 1000050624 1000050622 1000050198 1000050356 1000050018 1000049030 1000050866 1000050869 1000025986 1000036747 1000048630 1000050967 1000050968 1000033263 1000051011 1000051029 1000048009 1000051104 1000049043 1000051247 1000051248 1000041958 1000044898 1000050891 1000050515 1000051362 1000051371 1000051067 1000048665 1000047362 1000051435 1000051474 1000051485 1000051487 1000051512 1000049503 1000050749 1000051696 1000050244 1000051728 1000048241 1000051843 1000051933 1000051998 1000052002 1000049911 1000052037 1000052038 1000052039 1000036990 1000051883 1000051806 1000052158 1000050857 1000052224 1000051215 1000048311 1000051334 1000052286 1000036683 1000052310 1000052325 1000052326 1000052327 1000051282 1000052475 1000052479 1000052483 1000049637 1000052511 1000052512 1000052539 1000052544 1000052231 1000052232 1000039234 1000040058 1000040050 1000052750 1000052041 1000051993 1000052773 1000052775 1000052901 1000052908 1000052486 1000052437 1000052980 1000051097 1000053038 1000053053 1000052990 1000053011 1000052913 1000052584 1000052727 1000053332 1000053362 1000053365 1000053367 1000053378 1000053368 1000052975 1000050186 1000053463 1000053180 9848 ] |
9 | 2.32 ms |
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
]
|
10 | 1.40 ms |
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
]
|
11 | 0.25 ms |
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:
[
16
]
|
12 | 0.38 ms |
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:
[
17
]
|
13 | 0.21 ms |
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:
[
18
]
|
14 | 0.25 ms |
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:
[
19
]
|
15 | 0.19 ms |
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:
[
20
]
|
16 | 0.23 ms |
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:
[
21
]
|
17 | 0.25 ms |
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:
[
22
]
|
18 | 0.23 ms |
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:
[
23
]
|
19 | 0.22 ms |
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:
[
24
]
|
20 | 0.18 ms |
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:
[
25
]
|
21 | 0.17 ms |
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:
[
26
]
|
22 | 0.16 ms |
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:
[
27
]
|
23 | 0.16 ms |
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:
[
28
]
|
24 | 0.18 ms |
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:
[
29
]
|
25 | 0.17 ms |
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:
[
30
]
|
26 | 0.17 ms |
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:
[
31
]
|
27 | 0.18 ms |
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:
[
32
]
|
28 | 0.47 ms |
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:
[
9848
]
|
29 | 0.36 ms |
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:
[
"TarifDefautBtoB"
]
|
30 | 0.32 ms |
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"
]
|
31 | 0.21 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
32 | 0.19 ms |
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:
[
"TarifDefaut"
]
|
33 | 0.18 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
34 | 0.97 ms |
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" 80442 ] |
35 | 1.64 ms |
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:
[ 80442 0 ] |
36 | 0.55 ms |
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:
[ "C" 80442 ] |
37 | 0.23 ms |
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:
[
80442
]
|
38 | 0.23 ms |
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:
[
197554
]
|
39 | 0.24 ms |
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:
[
"TarifDefautBtoB"
]
|
40 | 0.46 ms |
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:
[ 80442 "C" ] |
41 | 0.46 ms |
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:
[ 80442 9963405 ] |
42 | 0.23 ms |
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:
[
"TarifDefautBtoB"
]
|
43 | 0.29 ms |
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"
]
|
44 | 0.19 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
45 | 0.26 ms |
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:
[
197554
]
|
46 | 1.36 ms |
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:
[
80442
]
|
47 | 0.32 ms |
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 11:07:24" "%2%" 80442 ] |
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.