Query Metrics
396
Database Queries
33
Different statements
267.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
191.32 ms (71.64%) |
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:
[ 25485 25478 25471 25484 25477 25470 25483 25476 25469 25482 25475 25468 25481 25474 25467 25480 25473 25466 24970 24969 24968 24967 27045 27044 21816 21813 21815 21812 21801 21797 21800 21796 21795 13566 13570 13569 13568 16490 13934 13992 13989 14053 14062 14059 14050 14056 14065 16727 16726 13933 13931 13935 16589 16588 13991 14052 14061 14049 14055 14064 27002 27001 27000 26999 26998 26997 25038 25037 25029 25028 25022 25017 20516 20514 20513 20510 20508 23750 23753 23752 23748 23751 23749 19415 19427 19423 19407 19419 19411 19414 19426 19422 19406 19418 19410 19413 19425 19421 19405 19417 19409 19981 19980 19979 19978 19977 19976 19975 19974 19986 19973 19985 19972 19984 19971 19983 19970 534 748 347 635 606 16729 16728 24878 25817 24877 24883 13878 13870 13874 13866 13877 13869 13873 13865 13876 13868 13872 13864 25828 22793 22783 22773 25827 22792 22782 22772 25826 22791 26810 22781 26809 22771 26808 25825 26807 22790 26806 22780 26805 22770 26804 25823 22788 22778 22768 25822 22787 22777 22767 25821 22786 22776 22766 25820 22785 22775 22765 26777 16646 16645 16658 26776 16644 16657 24651 13911 13908 13912 13909 26772 15525 24631 15518 15511 15524 24115 15517 15510 15523 24114 15516 15509 15522 24113 15515 15508 15521 24112 15514 15507 15520 24111 15513 15506 15999 15994 15989 15984 15979 15974 15969 15964 15959 15998 15993 15988 15983 15978 15973 15968 15963 15958 15997 15992 15987 15982 15977 15972 15967 15962 15957 15996 15991 15986 15981 15976 15971 15966 15961 15956 24607 24604 24606 24600 24603 24601 24605 24608 24602 23468 23486 23477 23467 23485 23476 23466 23484 23475 23465 23483 23474 23464 23482 23473 23463 23481 23472 23462 23480 23471 23461 23479 23470 23144 23135 23126 23117 23143 23134 23125 23116 23142 23133 23124 23115 23141 23132 23123 23114 23140 23131 23122 23113 23139 23130 23121 23112 23138 23129 23120 23111 23137 23128 23119 23110 23564 23563 23562 23561 23560 23559 23558 23557 23556 23555 23554 23553 23552 23551 23550 23549 23548 23547 23546 23545 23544 23543 23542 23541 23539 23538 23537 23536 23535 23534 23533 23532 23531 23530 23529 23528 23527 23526 23525 23524 23523 23522 23521 23520 23519 23518 23517 23164 23157 23150 22751 23163 23156 20015 22750 23162 23155 20014 22749 23161 23154 22755 22748 23160 23153 22754 22747 23159 23152 22753 20024 15727 15732 15726 26727 26726 26725 13689 19116 13674 13662 13656 13668 13650 13695 13683 13688 19115 13673 13661 13655 13667 13649 13694 13682 13687 13678 26721 26720 26719 26718 26717 15700 15705 15704 15703 15702 15667 15685 15694 15649 15658 15676 15640 15666 15684 15693 15648 15657 15675 15639 15665 15683 15692 15647 15656 15674 15638 15664 15682 15691 15646 15655 15673 15637 15663 15681 15690 15645 15654 15672 15636 15662 15680 15689 15644 15653 15671 15635 15661 15679 15688 15643 15652 15670 15634 15660 15678 15687 15642 15651 15669 15633 13672 13660 13654 13666 13648 13693 13681 13686 13677 13671 13659 13653 13665 13647 13692 13680 13685 13676 13670 13658 13652 13664 13646 13691 13679 25080 23824 26072 25074 25079 23823 26071 25073 25078 23822 26070 25072 25077 23821 26069 25071 25076 15562 15580 15589 15544 15553 15571 15535 15561 15579 15588 15543 15552 15570 15534 15560 15578 15587 15542 15551 15569 15533 15559 15577 15586 15541 15550 15568 15532 15558 15576 15585 15540 15549 15567 15531 15557 15575 15584 15539 15548 15566 15530 15556 15574 15583 15538 15547 15565 15529 15555 15573 15582 15537 15546 15564 15528 23820 26068 25070 23786 26073 25992 23792 15883 15887 23791 15882 15886 23790 15881 15885 24888 22937 15952 15948 24887 22936 15951 15947 24886 22935 15950 15946 13799 13797 13796 13794 13793 13795 13792 13791 13798 25092 23830 26665 25086 25091 23829 26664 25085 25090 23828 26663 25084 25089 23827 26662 25083 25088 23826 26661 25082 16970 16969 16968 9787 9830 9829 8978 8975 24175 24159 15478 24174 15473 24158 15477 24173 15472 24157 15476 24172 15471 24156 15475 24171 15470 24155 26438 26437 26436 26435 26434 16146 16141 16136 16131 16145 16140 16135 16130 16144 16139 16134 16129 16143 16138 16133 16128 26359 "precise_color" "product_size" ] |
|
12.04 ms (4.51%) |
72 |
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:
[
325532
]
|
|
9.65 ms (3.61%) |
108 |
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
]
|
|
8.04 ms (3.01%) |
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:
[
628
]
|
|
6.24 ms (2.34%) |
18 |
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:
[
25028
]
|
|
5.92 ms (2.22%) |
36 |
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:
[
"blue"
]
|
|
4.57 ms (1.71%) |
19 |
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:
[
25028
]
|
|
4.33 ms (1.62%) |
29 |
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"
]
|
|
4.00 ms (1.50%) |
19 |
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:
[
25028
]
|
|
2.48 ms (0.93%) |
9 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ WHERE m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.type = ? AND m0_.active = 1
Parameters:
[ "2026-10-27 18:18:28" "2026-10-27 18:18:28" "percent-soleil" ] |
|
2.33 ms (0.87%) |
16 |
SELECT t0.id AS id_1, t0.attributes_title AS attributes_title_2, t0.attributes_id AS attributes_id_3, t0.language_id AS language_id_4 FROM attributes_description t0 WHERE t0.attributes_id = ?
Parameters:
[
218
]
|
|
1.68 ms (0.63%) |
9 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters:
[ 25028 "2026-10-27 18:18:28" "2026-10-27 18:18:28" ] |
|
1.65 ms (0.62%) |
9 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
8103
]
|
|
1.48 ms (0.55%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1540 1539 1538 1537 1536 1535 367 2039 1090 1952 1951 1454 1857 1856 298 340 1533 264 1585 1584 2015 324 2024 2151 1942 1853 534 2159 209 1983 2022 1967 168 1852 461 2036 1471 2032 1720 1462 1897 1677 1662 1661 446 1819 1818 414 289 2027 2026 2028 1807 1806 1805 1804 1571 1570 1569 256 1919 2134 1918 1917 1916 1914 1913 1912 2025 2038 1477 1753 1974 460 1693 1692 1659 1658 1657 1220 1734 1209 1198 1187 1176 1165 1733 1157 1588 528 527 526 525 524 1799 2098 1798 1797 2097 1796 374 2077 1906 1905 1903 1989 1902 1988 1901 251 1982 1900 1981 1899 1898 45 1452 1750 1749 1979 1859 1997 2093 135 1950 1790 523 495 1789 1788 1978 1976 1106 1105 1107 180 411 2162 2145 1986 2012 1949 1948 1985 531 1787 1891 1472 1786 1892 1473 1890 1785 1784 1783 1465 1639 1638 1637 1636 1635 1634 1633 1487 1615 1614 1613 1612 1611 1610 1609 1885 1884 2074 1883 224 223 2291 2281 2270 2260 2249 2238 1608 1607 1606 1605 1604 1603 1686 1653 212 1880 203 197 1879 2073 1484 1461 1873 2160 1483 1777 1776 1775 215 1874 1881 1652 1684 1651 1746 1745 1744 1508 1507 1506 1497 1491 1486 1485 1480 1774 1773 1417 1408 1397 1386 1378 1375 1364 1357 321 370 320 1582 1581 1580 1751 1324 1313 1302 404 1934 1920 1911 502 515 1463 1987 345 339 304 308 318 305 371 372 2021 2020 1980 214 1467 2041 2031 2029 544 1647 1600 1599 1598 1597 1596 1595 1681 1594 1593 1592 1591 1590 1697 1747 1696 350 1759 1758 1757 1756 186 41 497 1464 2018 2014 306 ] |
|
1.38 ms (0.52%) |
9 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters:
[
25028
]
|
|
1.15 ms (0.43%) |
6 |
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:
[
"150"
]
|
|
0.98 ms (0.37%) |
4 |
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:
[
150
]
|
|
0.95 ms (0.35%) |
2 |
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_model_id = ?
Parameters:
[
1818
]
|
|
0.78 ms (0.29%) |
3 |
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.parent_id = ?
Parameters:
[
150
]
|
|
0.74 ms (0.28%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 59 59 59 60 60 60 60 102 102 102 107 107 107 107 107 107 107 107 48 181 213 235 319 355 364 392 394 231 231 387 113 202 202 113 113 326 113 113 113 113 113 172 175 175 175 175 175 175 258 258 258 294 294 294 172 172 59 313 313 313 313 313 313 313 314 314 314 314 323 323 323 323 323 323 326 326 326 326 326 326 326 364 364 364 364 364 364 364 314 436 323 438 443 443 444 456 456 457 313 436 438 444 444 430 313 457 59 60 436 436 436 430 48 48 51 57 63 63 63 63 111 111 111 111 111 133 133 133 133 133 134 134 134 139 140 139 140 144 144 144 144 150 150 167 167 181 181 192 202 206 213 213 206 228 228 228 231 231 231 235 247 247 247 247 248 248 248 248 252 254 254 254 254 255 255 255 252 252 57 276 277 192 278 278 288 57 292 292 296 302 303 303 57 276 276 319 330 330 296 277 355 358 355 377 377 381 381 387 388 388 388 392 392 394 394 387 394 392 202 228 140 192 139 140 255 276 296 288 213 277 52 52 52 52 52 52 ] |
|
0.71 ms (0.27%) |
3 |
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:
[
628
]
|
|
0.58 ms (0.22%) |
3 |
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:
[
628
]
|
|
0.57 ms (0.21%) |
3 |
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:
[
149
]
|
|
0.55 ms (0.20%) |
3 |
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:
[
149
]
|
|
0.52 ms (0.19%) |
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:
[ 175 367 394 1090 278 181 298 340 172 264 358 324 381 296 57 167 534 288 209 168 461 457 235 456 446 150 414 289 388 144 258 256 255 254 387 460 444 443 60 59 528 527 526 525 524 140 139 374 248 330 247 251 303 45 48 192 135 134 523 495 292 1106 1105 1107 180 411 277 276 531 133 231 364 326 228 224 223 52 323 438 212 213 203 197 202 111 215 206 436 113 107 321 370 320 294 51 102 404 252 502 515 319 345 339 304 308 318 305 371 372 377 302 214 392 544 314 313 430 350 63 186 41 497 355 306 ] |
|
0.47 ms (0.18%) |
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:
[ 25485 25478 25471 24970 24969 24968 24967 9748 27045 27044 ] |
|
0.42 ms (0.16%) |
3 |
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.40 ms (0.15%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.40 ms (0.15%) |
2 |
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_code = ? LIMIT 1
Parameters:
[
"product_size"
]
|
|
0.21 ms (0.08%) |
1 |
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:
[
4
]
|
|
0.20 ms (0.08%) |
1 |
SELECT p0_.id AS id_0, p0_.sort_order AS sort_order_1, p0_.products_id AS products_id_2, p0_.xsell_id AS xsell_id_3 FROM products_xsell p0_ INNER JOIN products p1_ ON p0_.xsell_id = p1_.products_id WHERE p0_.products_id = ? AND p1_.products_status = 1 ORDER BY p0_.sort_order ASC
Parameters:
[
25028
]
|
|
0.19 ms (0.07%) |
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.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
628
]
|
|
0.17 ms (0.06%) |
1 |
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:
[
"en"
]
|
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.