Query Metrics
634
Database Queries
50
Different statements
245.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
79.94 ms (32.53%) |
1 |
SELECT pa.products_id, a.attributes_code, pa.attributes_value FROM products_attributes pa INNER JOIN attributes a ON a.attributes_id = pa.attributes_id WHERE pa.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a.attributes_code IN (?)
Parameters:
[ 24947 24946 24945 24944 24943 24942 24941 18515 18514 18511 18480 18479 18492 18491 18486 18485 18490 18489 25127 23801 25931 25119 25124 23800 25930 25116 25125 23799 25929 14147 14145 14143 14144 14148 14146 14137 14139 14138 25117 25126 23798 25928 25118 25128 23797 25927 25120 25122 23796 25926 25114 25123 23795 25925 25115 22318 22310 22302 22294 22286 22317 22309 22301 22293 22285 22316 22308 22300 22292 22284 22315 22307 22299 22291 22283 22314 22306 22298 22290 22282 22313 22305 22297 22289 22281 22312 22304 22296 22288 22280 21372 21364 21356 21348 21340 21332 21324 21316 21308 21371 21363 21355 21347 21339 21331 21323 21315 21307 21370 21362 21354 21346 21338 21330 21322 21314 21306 21369 21361 21353 21345 21337 21329 21321 21313 21305 21368 21360 21352 21344 21336 21328 21320 21312 21304 21367 21359 21351 21343 21335 21327 21319 21311 21303 21366 21358 21350 21342 21334 21326 21318 21310 21302 21160 21158 21156 21161 21159 21157 20536 20535 20534 20533 20516 20514 20513 20531 20530 20529 20528 20510 20508 18713 18711 24755 24754 24753 24752 23724 23723 23722 23721 23720 23718 23717 23716 23714 23713 23712 23653 23652 23651 23650 23649 23709 23708 23710 23706 23705 23704 23703 18641 18640 18639 18644 18643 18642 18638 18637 18636 18584 18588 18583 18587 19164 19163 18618 18617 18621 18620 20001 19997 20000 19996 20591 20590 20589 14151 25068 23787 25067 25064 23818 25063 18699 18698 18697 18696 18695 18694 18693 18692 18691 18662 18661 18660 18656 18655 18654 18679 18680 18653 18652 18651 18650 18649 18648 18647 18646 18645 20566 20565 20564 14961 20563 14960 20562 14959 14958 20561 20560 20559 20558 20557 20556 20555 20554 20553 20549 20551 20550 18572 20548 18567 20547 18565 18560 14135 14133 14132 14130 14129 14131 14128 14136 14134 20546 20545 20544 20543 20542 20541 20540 20539 20538 26636 22763 22762 22761 26635 22759 22758 22757 22345 22344 22343 22337 22336 22335 22369 22368 22367 22365 22364 22363 22361 22360 22359 22357 22356 22355 22353 22352 22351 22349 22348 22347 20600 20599 23744 23743 20597 20596 20594 20593 22333 22332 22331 22330 22328 22327 22326 22325 22323 22322 22321 22320 20587 20586 20585 20584 20583 20582 20580 20579 20578 20577 20576 20575 20573 20572 20571 20570 20569 20568 20618 20617 20609 20608 8582 8678 18542 18541 18540 18539 16182 16178 16174 16170 16181 16177 16173 16169 16180 16176 16172 16168 "precise_color" ] |
|
29.47 ms (11.99%) |
1 |
SELECT pa.products_id, a.attributes_code, pa.attributes_value FROM products_attributes pa INNER JOIN attributes a ON a.attributes_id = pa.attributes_id WHERE pa.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a.attributes_code IN (?, ?)
Parameters:
[ 26030 26029 26028 26027 26026 26036 26035 26034 26033 26032 26020 26019 26018 26024 26023 26022 25761 25760 25759 25758 25756 25755 25754 25753 25751 25750 25749 25748 25739 25164 20012 20009 20006 20021 17830 17826 20018 20011 20008 20005 20020 17829 17825 20017 20010 20007 20004 20019 20022 20013 20016 24864 24101 24097 24100 24096 24099 24095 23080 23062 22893 22890 24642 24644 24646 24641 24643 24645 22250 22253 21431 21430 21429 21189 21203 21191 21205 21188 21187 21186 21185 21184 22062 22061 22060 22059 13031 13030 13027 13002 13001 13000 12999 12998 12997 17639 17631 17623 17615 17638 17630 17622 17614 17637 17629 17621 17613 17636 17628 17620 17612 17635 17627 17619 17611 17634 17626 17618 17610 17633 17625 17617 17609 24430 19950 19946 19942 24429 19949 19945 19941 24428 19948 22267 22266 22265 17901 17895 17900 17894 17899 17893 17898 17892 17897 17891 19944 19940 17687 17683 17679 17675 17686 17682 17678 17674 19710 17681 17677 17673 17660 17653 17659 17652 17658 17651 17657 17650 17656 17649 17655 17648 "technical_material" "precise_color" ] |
|
21.15 ms (8.61%) |
80 |
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
27148
]
|
|
17.34 ms (7.06%) |
80 |
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
27148
]
|
|
13.62 ms (5.54%) |
82 |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
430
]
|
|
11.84 ms (4.82%) |
82 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"VV"
]
|
|
10.20 ms (4.15%) |
121 |
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7, t0.attributes_suffix AS attributes_suffix_8 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
250
]
|
|
5.32 ms (2.16%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 893 701 703 702 462 909 631 1402 1026 ] |
|
5.08 ms (2.07%) |
23 |
SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.label AS label_4, t0.heading_title AS heading_title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_video AS products_video_13, t0.products_conseil1 AS products_conseil1_14, t0.products_notice AS products_notice_15, t0.products_tags AS products_tags_16, t0.products_models_id AS products_models_id_17, t0.language_id AS language_id_18 FROM products_models_description t0 WHERE t0.products_models_id = ?
Parameters:
[
396
]
|
|
4.84 ms (1.97%) |
30 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.listing_axis AS listing_axis_6, t0.products_cat AS products_cat_7, t0.parent_id AS parent_id_8, t0.manufacturers_id AS manufacturers_id_9, t0.variant_id AS variant_id_10, t0.default_product_id AS default_product_id_11 FROM products_models t0 WHERE t0.id = ?
Parameters:
[
2062
]
|
|
4.73 ms (1.92%) |
28 |
SELECT t0.colors_id AS colors_id_1, t0.colors_code AS colors_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.colors_code = ? LIMIT 1
Parameters:
[
"multicolor"
]
|
|
4.29 ms (1.74%) |
14 |
SELECT t0.products_attributes_id AS products_attributes_id_1, t0.attributes_value AS attributes_value_2, t0.products_id AS products_id_3, t0.attributes_id AS attributes_id_4 FROM products_attributes t0 WHERE t0.products_id = ?
Parameters:
[
24947
]
|
|
4.17 ms (1.70%) |
1 |
SELECT pa.products_id, a.attributes_code, pa.attributes_value FROM products_attributes pa INNER JOIN attributes a ON a.attributes_id = pa.attributes_id WHERE pa.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a.attributes_code IN (?)
Parameters:
[ 25693 25692 25691 25690 25689 25688 25687 25686 25669 25668 25667 25666 25665 25664 25663 25662 "precise_color" ] |
|
4.09 ms (1.66%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 457 1837 687 689 1333 1431 690 1370 1371 692 1325 1800 1014 1831 ] |
|
3.56 ms (1.45%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 1735 460 1623 1691 1658 1709 901 1331 461 1636 1731 ] |
|
3.43 ms (1.40%) |
14 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.products_attributes_id AS products_attributes_id_3, t0.language_id AS language_id_4 FROM products_attributes_description t0 WHERE t0.products_attributes_id = ?
Parameters:
[
396109
]
|
|
3.13 ms (1.28%) |
8 |
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.is_default_variant AS is_default_variant_65, p0_.products_parent_id AS products_parent_id_66, p0_.products_model_id AS products_model_id_67, p0_.manufacturers_id AS manufacturers_id_68, p0_.products_tax_class_id AS products_tax_class_id_69 FROM products p0_ WHERE p0_.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 27148 12149 10958 10957 22674 22706 22705 22704 9579 18470 ] |
|
2.78 ms (1.13%) |
2 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 459 948 1614 1708 1671 1068 1330 1428 1732 1584 557 1430 1733 ] |
|
2.40 ms (0.98%) |
1 |
SELECT pa.products_id, a.attributes_code, pa.attributes_value FROM products_attributes pa INNER JOIN attributes a ON a.attributes_id = pa.attributes_id WHERE pa.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a.attributes_code IN (?)
Parameters:
[ 22062 22061 22060 22059 22054 22053 22052 22051 22050 22049 22047 22046 "technical_material" ] |
|
2.07 ms (0.84%) |
10 |
SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = ?
Parameters:
[
430
]
|
|
1.53 ms (0.62%) |
9 |
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
|
1.27 ms (0.52%) |
2 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 1372 1369 1373 1368 1367 1025 924 1043 ] |
|
1.10 ms (0.45%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[ 1027 1028 674 1727 ] |
|
1.09 ms (0.44%) |
6 |
SELECT t0.id AS id_1, t0.manufacturers_title AS manufacturers_title_2, t0.manufacturers_url AS manufacturers_url_3, t0.manufacturers_description1 AS manufacturers_description1_4, t0.manufacturers_description2 AS manufacturers_description2_5, t0.manufacturers_head_title_tag AS manufacturers_head_title_tag_6, t0.manufacturers_head_desc_tag AS manufacturers_head_desc_tag_7, t0.manufacturers_head_keywords_tag AS manufacturers_head_keywords_tag_8, t0.url_clicked AS url_clicked_9, t0.date_last_click AS date_last_click_10, t0.manufacturers_id AS manufacturers_id_11, t0.languages_id AS languages_id_12 FROM manufacturers_info t0 WHERE t0.manufacturers_id = ?
Parameters:
[
158
]
|
|
1.06 ms (0.43%) |
6 |
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.manufacturers_name AS manufacturers_name_3, t0.manufacturers_image AS manufacturers_image_4, t0.date_added AS date_added_5, t0.last_modified AS last_modified_6, t0.manufacturers_statuts AS manufacturers_statuts_7, t0.manufacturers_order AS manufacturers_order_8, t0.manufacturers_locked_price AS manufacturers_locked_price_9, t0.manufacturers_welcome AS manufacturers_welcome_10, t0.manufacturers_export AS manufacturers_export_11, t0.manufacturers_no_soleil AS manufacturers_no_soleil_12 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters:
[
158
]
|
|
0.62 ms (0.25%) |
4 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.axis1 AS axis1_4, t0.axis2 AS axis2_5 FROM products_models_variants t0 WHERE t0.id = ?
Parameters:
[
28
]
|
|
0.41 ms (0.17%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2062 2061 2060 2040 2037 2035 2034 267 174 243 211 297 343 266 342 1851 1850 1848 166 261 1847 1846 1845 1844 2005 2004 2003 2002 2001 2000 1999 446 1836 1835 289 1587 1586 1573 1572 2027 2026 2028 271 130 329 129 128 328 439 126 125 124 123 2120 2118 2119 2117 2124 2123 2122 2121 335 245 244 97 89 86 96 95 93 75 451 74 78 92 91 90 88 87 400 85 242 241 399 398 397 84 82 81 80 79 77 76 73 71 70 69 68 67 356 240 238 521 36 35 1008 66 1748 1264 1253 1242 ] |
|
0.35 ms (0.14%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2297 2296 2295 2294 2293 2289 2288 2287 2248 2247 2246 2245 1005 1001 1150 2236 2235 998 1041 1039 2310 2266 2284 2265 1163 2210 2208 2207 2206 2234 978 977 976 1012 1010 1009 2283 2282 2280 2279 2278 1 6 1055 1154 1153 1409 1407 1406 1405 1404 1403 1402 2226 2225 2223 973 1390 1389 1388 1387 1385 2222 2221 2220 1401 1400 1399 1398 1396 1395 1008 ] |
|
0.33 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.redirect_url AS redirect_url_2, t0.target_path AS target_path_3, t0.target_url AS target_url_4, t0.redirect_product_id AS redirect_product_id_5, t0.redirect_category_id AS redirect_category_id_6, t0.target_product_id AS target_product_id_7, t0.target_category_id AS target_category_id_8 FROM redirections t0 WHERE t0.redirect_category_id = ? LIMIT 1
Parameters:
[
430
]
|
|
0.31 ms (0.13%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 396 267 174 243 211 297 343 266 342 162 166 261 337 446 156 289 259 388 271 130 329 129 128 328 439 126 125 124 123 489 488 492 491 335 245 244 97 89 86 96 95 93 75 451 74 78 92 91 90 88 87 400 85 242 241 399 398 397 84 82 81 80 79 77 76 73 71 70 69 68 67 356 240 238 521 36 35 1008 66 47 65 ] |
|
0.28 ms (0.11%) |
2 |
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = ?
Parameters:
[
1
]
|
|
0.27 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.27 ms (0.11%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 1026 1024 1006 1005 1001 1150 999 998 1041 1039 1031 1016 1053 985 984 983 994 978 977 976 1012 1010 1009 1020 1 6 1055 1051 991 989 973 990 988 987 1008 ] |
|
0.26 ms (0.10%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[
1826
]
|
|
0.25 ms (0.10%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1051 1051 1053 990 990 990 990 990 987 987 987 987 987 987 991 991 991 991 991 991 991 983 984 984 985 988 988 988 989 989 989 994 999 999 1006 1006 1006 1006 1016 1016 1020 1020 1020 1020 1020 1016 1024 1024 1024 1026 1026 1026 1026 1026 1031 ] |
|
0.25 ms (0.10%) |
1 |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
"430"
]
|
|
0.25 ms (0.10%) |
1 |
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.is_default_variant AS is_default_variant_65, p0_.products_parent_id AS products_parent_id_66, p0_.products_model_id AS products_model_id_67, p0_.manufacturers_id AS manufacturers_id_68, p0_.products_tax_class_id AS products_tax_class_id_69 FROM products p0_ WHERE p0_.products_id IN (?)
Parameters:
[
25981
]
|
|
0.25 ms (0.10%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 65 65 65 259 259 259 259 47 156 156 162 162 162 162 162 162 162 337 337 337 337 337 337 337 388 388 388 396 396 396 396 396 396 396 488 488 489 489 491 491 492 492 ] |
|
0.24 ms (0.10%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 758 715 733 801 698 821 820 741 712 1141 1140 811 735 802 759 732 800 38 757 731 803 797 804 799 754 795 774 777 716 773 772 771 770 769 718 768 766 765 764 763 762 761 775 760 1093 755 748 753 752 ] |
|
0.23 ms (0.09%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 758 715 733 801 698 821 820 741 712 1141 1140 811 735 802 759 732 800 38 757 731 803 797 804 799 754 795 774 777 716 773 772 771 770 769 718 768 766 765 764 763 762 761 775 760 1093 755 748 753 752 ] |
|
0.22 ms (0.09%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 1071 1070 1061 1073 1062 1072 1056 1069 1060 1059 1058 1057 1068 1076 1067 1075 1074 1066 1065 1064 1063 1078 ] |
|
0.18 ms (0.07%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?) AND m.listing_axis IS NOT NULL
Parameters:
[
11
]
|
|
0.18 ms (0.07%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 670 2333 626 615 604 593 582 564 870 778 691 680 1142 866 553 542 756 745 723 713 702 532 972 970 694 956 945 ] |
|
0.18 ms (0.07%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1057 1057 1056 1056 1061 1061 1062 1062 ] |
|
0.18 ms (0.07%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1071 1070 1433 1432 1073 1435 1434 1072 1431 1430 1069 1060 1059 1058 1429 1428 1068 1076 1067 1075 1074 1066 1065 1064 1063 1078 ] |
|
0.17 ms (0.07%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 395 384 373 363 808 798 352 344 333 322 1 10 9 8 7 6 ] |
|
0.15 ms (0.06%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 670 2333 626 615 604 593 582 564 870 778 691 680 1504 1505 1946 1935 1925 1904 1893 1882 1915 1871 1860 1849 756 745 723 713 702 1838 972 970 694 956 945 1977 ] |
|
0.15 ms (0.06%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1142 1142 532 542 542 542 542 553 553 542 553 866 866 532 ] |
|
0.15 ms (0.06%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 395 384 373 363 808 798 352 344 333 322 1 10 9 8 7 6 ] |
|
0.11 ms (0.04%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?)
Parameters:
[
11
]
|
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.