Query Metrics
420
Database Queries
30
Different statements
592.37 ms
Query time
7
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.63 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
2 | 0.26 ms |
SELECT DATABASE()
Parameters:
[] |
3 | 0.75 ms |
SELECT p0_.id AS id_0, p0_.meta_title AS meta_title_1, p0_.meta_description AS meta_description_2, p0_.name AS name_3, p0_.meta_keywords AS meta_keywords_4, p0_.content AS content_5, p0_.link_rewrite AS link_rewrite_6, p0_.redirect AS redirect_7, p0_.id_cms AS id_cms_8, p0_.id_lang AS id_lang_9 FROM ps_cms_lang p0_ INNER JOIN ps_cms p1_ ON p0_.id_cms = p1_.id_cms WHERE p0_.link_rewrite = ? AND p0_.id_lang = ?
Parameters:
[ "sesity-bloky-papiru-a-deniky-sesity-na-psani.html" 28 ] |
4 | 0.74 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.is_root_category AS is_root_category_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.reference AS reference_6, t0.id_parent AS id_parent_7, t0.id_image AS id_image_8 FROM taxonomy t0 WHERE t0.id = ?
Parameters:
[
16059
]
|
5 | 0.71 ms |
SELECT COALESCE(t0_.name, t1_.name, t2_.name) AS sclr_0, COALESCE(t0_.link_rewrite, t1_.link_rewrite, t2_.link_rewrite) AS sclr_1, COALESCE(t0_.description, t1_.description, t2_.description) AS sclr_2 FROM taxonomy_lang t0_ INNER JOIN taxonomy t3_ ON t0_.id_taxonomy = t3_.id LEFT JOIN taxonomy_lang t1_ ON (t3_.id = t1_.id_taxonomy AND t1_.id_lang = 1) LEFT JOIN taxonomy_lang t2_ ON (t3_.id = t2_.id_taxonomy AND t2_.id_lang = 4) LEFT JOIN ps_lang p4_ ON t0_.id_lang = p4_.id_lang WHERE t0_.id_lang = ? AND t3_.id = ?
Parameters:
[ 28 16059 ] |
6 | 418.07 ms |
SELECT t0_.id_taxonomy AS id_taxonomy_0, t0_.id_parent AS id_parent_1, t0_.name AS name_2, t0_.description AS description_3, t0_.link_rewrite AS link_rewrite_4, t0_.product_count AS product_count_5, t0_.id_image AS id_image_6, t0_.image_name AS image_name_7, t0_.is_gif AS is_gif_8 FROM taxonomy_info t0_ WHERE t0_.id_language = ? AND t0_.id_taxonomy NOT IN (?) ORDER BY t0_.name ASC
Parameters:
[ 28 31548 ] |
7 | 1.02 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ?
Parameters:
[
16059
]
|
8 | 0.33 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.is_root_category AS is_root_category_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.reference AS reference_6, t0.id_parent AS id_parent_7, t0.id_image AS id_image_8 FROM taxonomy t0 WHERE t0.id = ?
Parameters:
[
16049
]
|
9 | 0.52 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ?
Parameters:
[
16049
]
|
10 | 0.23 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.is_root_category AS is_root_category_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.reference AS reference_6, t0.id_parent AS id_parent_7, t0.id_image AS id_image_8 FROM taxonomy t0 WHERE t0.id = ?
Parameters:
[
16048
]
|
11 | 1.40 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ?
Parameters:
[
16048
]
|
12 | 0.56 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.is_root_category AS is_root_category_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.reference AS reference_6, t0.id_parent AS id_parent_7, t0.id_image AS id_image_8 FROM taxonomy t0 WHERE t0.id = ?
Parameters:
[
19664
]
|
13 | 0.50 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ?
Parameters:
[
19664
]
|
14 | 0.49 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 1 ] |
15 | 0.38 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0
Parameters:
[] |
16 | 0.33 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 4 ] |
17 | 0.29 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 5 ] |
18 | 0.28 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 6 ] |
19 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 7 ] |
20 | 0.27 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 8 ] |
21 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 9 ] |
22 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 10 ] |
23 | 0.23 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 11 ] |
24 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 12 ] |
25 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 13 ] |
26 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 14 ] |
27 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 15 ] |
28 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 16 ] |
29 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 18 ] |
30 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 19 ] |
31 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 20 ] |
32 | 0.23 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 21 ] |
33 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 22 ] |
34 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 24 ] |
35 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 25 ] |
36 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 26 ] |
37 | 0.23 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 27 ] |
38 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 28 ] |
39 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 28 ] |
40 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
41 | 1.16 ms |
INSERT INTO ps_customer_stats (id_customer, id_lang, url_referer, gadw_matchtype, gadw_network, gadw_keyword, utm_source, utm_medium, utm_campaign, data, date, gclid, fblid, default_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 28 null null null null null null null null "2025-02-27 01:02:35" null null 1 ] |
42 | 4.80 ms |
"COMMIT"
Parameters:
[] |
43 | 0.75 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
44 | 0.59 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
45 | 1.54 ms |
SELECT m0_.id AS id_0, m0_.parent AS sclr_1, m0_.link_type AS link_type_2, m0_.link_value AS link_value_3, m0_.tag AS tag_4, m0_.number_columns AS number_columns_5, m0_.colspan AS colspan_6, m0_.additional AS additional_7, m0_.icon AS icon_8, m0_.target AS target_9, IF(m1_.title IS NULL OR m1_.title = '', IF(m2_.title IS NULL OR m2_.title = '', IF(m3_.title IS NULL OR m3_.title = '', '', m3_.title), m2_.title), m1_.title) AS sclr_10, IF(m1_.subtitle IS NULL OR m1_.subtitle = '', IF(m2_.subtitle IS NULL OR m2_.subtitle = '', IF(m3_.subtitle IS NULL OR m3_.subtitle = '', '', m3_.subtitle), m2_.subtitle), m1_.subtitle) AS sclr_11 FROM menu_item m0_ LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id AND (m1_.language_id = ?) LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id AND (m2_.language_id = 1) LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id AND (m3_.language_id = 4) WHERE m0_.menu_id = ? AND m0_.visibility = ? ORDER BY m0_.position ASC
Parameters:
[ 28 1 1 ] |
46 | 4.43 ms |
SELECT p0_.id_cms AS sclr_0, p1_.id_lang AS id_lang_1, p0_.link_rewrite AS link_rewrite_2 FROM ps_cms_lang p0_ INNER JOIN ps_lang p1_ ON p0_.id_lang = p1_.id_lang
Parameters:
[] |
47 | 2.16 ms |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.name AS name_4, t0.meta_keywords AS meta_keywords_5, t0.content AS content_6, t0.link_rewrite AS link_rewrite_7, t0.redirect AS redirect_8, t0.id_cms AS id_cms_9, t0.id_lang AS id_lang_10 FROM ps_cms_lang t0 WHERE t0.link_rewrite = ? LIMIT 1
Parameters:
[
"sesity-bloky-papiru-a-deniky-sesity-na-psani.html"
]
|
48 | 0.66 ms |
SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.iso_code AS iso_code_2, p0_.iso_code_real AS iso_code_real_3 FROM ps_lang p0_ WHERE p0_.active = 1
Parameters:
[] |
49 | 0.41 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 1 ] |
50 | 0.32 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 4 ] |
51 | 0.31 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 5 ] |
52 | 0.30 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 6 ] |
53 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 7 ] |
54 | 0.27 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 8 ] |
55 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 9 ] |
56 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 10 ] |
57 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 11 ] |
58 | 0.31 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 12 ] |
59 | 0.28 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 13 ] |
60 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 14 ] |
61 | 0.27 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 15 ] |
62 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 16 ] |
63 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 18 ] |
64 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 19 ] |
65 | 0.23 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 20 ] |
66 | 0.27 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 21 ] |
67 | 0.26 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 22 ] |
68 | 0.28 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 24 ] |
69 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 25 ] |
70 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 26 ] |
71 | 0.24 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 27 ] |
72 | 0.25 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 16059 28 ] |
73 | 0.56 ms |
SELECT p0_.id_category AS id_category_0, p0_.active AS active_1, p1_.name AS name_2, p1_.description AS description_3, p1_.link_rewrite AS link_rewrite_4, p1_.meta_title AS meta_title_5, p1_.meta_description AS meta_description_6, p1_.meta_keywords AS meta_keywords_7, p1_.id_category AS id_category_8, p1_.id_lang AS id_lang_9 FROM ps_category p0_ INNER JOIN ps_category_lang p1_ ON p0_.id_category = p1_.id_category WHERE p0_.id_category IN (?, ?, ?, ?) AND p1_.id_lang = ?
Parameters:
[ 2672 2202 2488 3150 28 ] |
74 | 1.33 ms |
SELECT p0_.id_tag AS id_tag_0, p0_.name AS name_1, p0_.link_rewrite AS link_rewrite_2, p0_.alt AS alt_3, p0_.description AS description_4, p0_.Book_keeper AS Book_keeper_5, p0_.active AS active_6, p0_.deleted AS deleted_7, p0_.id_lang AS id_lang_8 FROM ps_tag p0_ WHERE p0_.id_tag IN (?, ?, ?, ?, ?) AND p0_.id_lang = ?
Parameters:
[ 35 100 66 72 85 28 ] |
75 | 0.69 ms |
SELECT p0_.id_manufacturer AS id_manufacturer_0, p0_.name AS name_1, p1_.link_rewrite AS link_rewrite_2, p2_.iso_code AS iso_code_3 FROM ps_manufacturer p0_ INNER JOIN ps_manufacturer_lang p1_ ON p0_.id_manufacturer = p1_.id_manufacturer INNER JOIN ps_lang p2_ ON p1_.id_lang = p2_.id_lang WHERE p0_.id_manufacturer IN (?) AND p2_.id_lang = ? AND p0_.active = ?
Parameters:
[ 2317 28 1 ] |
76 | 0.19 ms |
SELECT DATABASE()
Parameters:
[] |
77 | 0.57 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17088 ] |
78 | 0.36 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 17088 31548 ] |
79 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17089 ] |
80 | 0.41 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17094 ] |
81 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17108 ] |
82 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17113 ] |
83 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17182 ] |
84 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17190 ] |
85 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17191 ] |
86 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17208 ] |
87 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 20454 ] |
88 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 20455 ] |
89 | 0.29 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 20456 ] |
90 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19648 ] |
91 | 0.36 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19648 31548 ] |
92 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 915 ] |
93 | 0.42 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1405 ] |
94 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3197 ] |
95 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3531 ] |
96 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3543 ] |
97 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3651 ] |
98 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4084 ] |
99 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6860 ] |
100 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 9599 ] |
101 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11403 ] |
102 | 0.40 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11464 ] |
103 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12288 ] |
104 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13620 ] |
105 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13742 ] |
106 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13813 ] |
107 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 15086 ] |
108 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16122 ] |
109 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16940 ] |
110 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19673 ] |
111 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19674 ] |
112 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19649 ] |
113 | 0.33 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19649 31548 ] |
114 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 968 ] |
115 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3366 ] |
116 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6758 ] |
117 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 9703 ] |
118 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11346 ] |
119 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13691 ] |
120 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16478 ] |
121 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17067 ] |
122 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17220 ] |
123 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19675 ] |
124 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19676 ] |
125 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19650 ] |
126 | 0.31 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19650 31548 ] |
127 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1019 ] |
128 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2163 ] |
129 | 0.41 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5324 ] |
130 | 1.53 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5419 ] |
131 | 0.68 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11496 ] |
132 | 0.51 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11702 ] |
133 | 0.43 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14091 ] |
134 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18828 ] |
135 | 0.40 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19651 ] |
136 | 0.39 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19651 31548 ] |
137 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 444 ] |
138 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4294 ] |
139 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7609 ] |
140 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8944 ] |
141 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10457 ] |
142 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10516 ] |
143 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13669 ] |
144 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14921 ] |
145 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 15436 ] |
146 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17535 ] |
147 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19677 ] |
148 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19652 ] |
149 | 0.36 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19652 31548 ] |
150 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 280 ] |
151 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 888 ] |
152 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5272 ] |
153 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6938 ] |
154 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 9502 ] |
155 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12323 ] |
156 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14316 ] |
157 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14818 ] |
158 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14904 ] |
159 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16093 ] |
160 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18767 ] |
161 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19678 ] |
162 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19679 ] |
163 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19653 ] |
164 | 0.34 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19653 31548 ] |
165 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1938 ] |
166 | 0.29 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4036 ] |
167 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4082 ] |
168 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7441 ] |
169 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8122 ] |
170 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8732 ] |
171 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11392 ] |
172 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16442 ] |
173 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18372 ] |
174 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18805 ] |
175 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19660 ] |
176 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19672 ] |
177 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19682 ] |
178 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19684 ] |
179 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19686 ] |
180 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19687 ] |
181 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19894 ] |
182 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19654 ] |
183 | 0.35 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19654 31548 ] |
184 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 513 ] |
185 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2717 ] |
186 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2904 ] |
187 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11485 ] |
188 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11493 ] |
189 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12319 ] |
190 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16538 ] |
191 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19688 ] |
192 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19689 ] |
193 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19656 ] |
194 | 0.36 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19656 31548 ] |
195 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1310 ] |
196 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2184 ] |
197 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3134 ] |
198 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4428 ] |
199 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5032 ] |
200 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5517 ] |
201 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5684 ] |
202 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7568 ] |
203 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10953 ] |
204 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12229 ] |
205 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12651 ] |
206 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13601 ] |
207 | 1.42 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13869 ] |
208 | 1.50 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16490 ] |
209 | 1.28 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18660 ] |
210 | 0.42 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18853 ] |
211 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19691 ] |
212 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19692 ] |
213 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19693 ] |
214 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 21087 ] |
215 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19657 ] |
216 | 0.32 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19657 31548 ] |
217 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10333 ] |
218 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19658 ] |
219 | 0.35 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19658 31548 ] |
220 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1653 ] |
221 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7065 ] |
222 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8836 ] |
223 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8906 ] |
224 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10407 ] |
225 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 15501 ] |
226 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 15580 ] |
227 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17002 ] |
228 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17761 ] |
229 | 0.29 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17797 ] |
230 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17917 ] |
231 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18460 ] |
232 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19695 ] |
233 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19696 ] |
234 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19697 ] |
235 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19699 ] |
236 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19700 ] |
237 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19701 ] |
238 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19661 ] |
239 | 0.32 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19661 31548 ] |
240 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1301 ] |
241 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2096 ] |
242 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3281 ] |
243 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5616 ] |
244 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10743 ] |
245 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14979 ] |
246 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 15046 ] |
247 | 0.94 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19703 ] |
248 | 0.60 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19965 ] |
249 | 0.47 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19662 ] |
250 | 0.41 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19662 31548 ] |
251 | 0.43 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2588 ] |
252 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10095 ] |
253 | 0.39 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12816 ] |
254 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13376 ] |
255 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13499 ] |
256 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19758 ] |
257 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19663 ] |
258 | 0.39 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19663 31548 ] |
259 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 974 ] |
260 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1096 ] |
261 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3267 ] |
262 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6686 ] |
263 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10737 ] |
264 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11022 ] |
265 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11023 ] |
266 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11190 ] |
267 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13066 ] |
268 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13863 ] |
269 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16415 ] |
270 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16460 ] |
271 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19705 ] |
272 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19706 ] |
273 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19707 ] |
274 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19708 ] |
275 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19709 ] |
276 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19759 ] |
277 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19664 ] |
278 | 0.35 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19664 31548 ] |
279 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2923 ] |
280 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3268 ] |
281 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6903 ] |
282 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11817 ] |
283 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11986 ] |
284 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12640 ] |
285 | 0.29 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16048 ] |
286 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17410 ] |
287 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19710 ] |
288 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19666 ] |
289 | 0.33 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19666 31548 ] |
290 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1968 ] |
291 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19715 ] |
292 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19716 ] |
293 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19717 ] |
294 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19718 ] |
295 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19719 ] |
296 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19720 ] |
297 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19721 ] |
298 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19722 ] |
299 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19667 ] |
300 | 0.32 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19667 31548 ] |
301 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19723 ] |
302 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19724 ] |
303 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19725 ] |
304 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19726 ] |
305 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19727 ] |
306 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19668 ] |
307 | 0.31 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19668 31548 ] |
308 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16541 ] |
309 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19728 ] |
310 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19729 ] |
311 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19730 ] |
312 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19731 ] |
313 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19732 ] |
314 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19669 ] |
315 | 0.32 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19669 31548 ] |
316 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2526 ] |
317 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5224 ] |
318 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5399 ] |
319 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6451 ] |
320 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 9749 ] |
321 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18107 ] |
322 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19733 ] |
323 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19734 ] |
324 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19735 ] |
325 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19736 ] |
326 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19671 ] |
327 | 0.35 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19671 31548 ] |
328 | 1.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 425 ] |
329 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19348 ] |
330 | 0.82 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19685 ] |
331 | 0.48 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19685 31548 ] |
332 | 0.46 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19670 ] |
333 | 0.39 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19902 ] |
334 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19903 ] |
335 | 0.39 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19904 ] |
336 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19905 ] |
337 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19906 ] |
338 | 0.27 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19907 ] |
339 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19908 ] |
340 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19909 ] |
341 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19910 ] |
342 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19911 ] |
343 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19912 ] |
344 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19913 ] |
345 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19914 ] |
346 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19756 ] |
347 | 0.47 ms |
SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (?) AND t0_.active = 1 AND t0_.id NOT IN (?)
Parameters:
[ 19756 31548 ] |
348 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2 ] |
349 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1171 ] |
350 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1498 ] |
351 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 1892 ] |
352 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2026 ] |
353 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2071 ] |
354 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2571 ] |
355 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2683 ] |
356 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2711 ] |
357 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 2982 ] |
358 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3025 ] |
359 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3061 ] |
360 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3294 ] |
361 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3415 ] |
362 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3683 ] |
363 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 3731 ] |
364 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 4989 ] |
365 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5569 ] |
366 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5600 ] |
367 | 1.17 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 5906 ] |
368 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6251 ] |
369 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 6264 ] |
370 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7034 ] |
371 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7482 ] |
372 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7546 ] |
373 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 7948 ] |
374 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8427 ] |
375 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8476 ] |
376 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8480 ] |
377 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8564 ] |
378 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 8597 ] |
379 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 9845 ] |
380 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 10226 ] |
381 | 0.95 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11305 ] |
382 | 0.59 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 11460 ] |
383 | 0.42 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 12227 ] |
384 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 13812 ] |
385 | 1.12 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14115 ] |
386 | 0.39 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 14878 ] |
387 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16278 ] |
388 | 0.40 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16426 ] |
389 | 0.33 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16816 ] |
390 | 0.35 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 16844 ] |
391 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17430 ] |
392 | 0.32 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 17503 ] |
393 | 1.06 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18386 ] |
394 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18734 ] |
395 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18800 ] |
396 | 0.36 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 18998 ] |
397 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19680 ] |
398 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19681 ] |
399 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = ?) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = ?
Parameters:
[ 28 19757 ] |
400 | 0.31 ms |
SELECT t0.id_configuration AS id_configuration_1, t0.name AS name_2, t0.value AS value_3 FROM ps_configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"LOGO_NAVIDAD"
]
|
401 | 0.66 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
402 | 0.44 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"cs"
]
|
403 | 0.86 ms |
SELECT m0_.id AS id_0, m0_.parent AS sclr_1, m0_.link_type AS link_type_2, m0_.link_value AS link_value_3, m0_.tag AS tag_4, m0_.number_columns AS number_columns_5, m0_.colspan AS colspan_6, m0_.additional AS additional_7, m0_.icon AS icon_8, m0_.target AS target_9, IF(m1_.title IS NULL OR m1_.title = '', IF(m2_.title IS NULL OR m2_.title = '', IF(m3_.title IS NULL OR m3_.title = '', '', m3_.title), m2_.title), m1_.title) AS sclr_10, IF(m1_.subtitle IS NULL OR m1_.subtitle = '', IF(m2_.subtitle IS NULL OR m2_.subtitle = '', IF(m3_.subtitle IS NULL OR m3_.subtitle = '', '', m3_.subtitle), m2_.subtitle), m1_.subtitle) AS sclr_11 FROM menu_item m0_ LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id AND (m1_.language_id = ?) LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id AND (m2_.language_id = 1) LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id AND (m3_.language_id = 4) WHERE m0_.menu_id = ? AND m0_.visibility = ? ORDER BY m0_.position ASC
Parameters:
[ 28 2 1 ] |
404 | 0.32 ms |
SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.iso_code AS iso_code_2, p0_.iso_code_real AS iso_code_real_3 FROM ps_lang p0_ WHERE p0_.active = 1
Parameters:
[] |
legacy connection
#▲ | Time | Info |
---|---|---|
1 | 0.44 ms |
SELECT * FROM `ps_lang` WHERE iso_code = :iso_code AND active = 1
Parameters:
[ ":iso_code" => "cs" ] |
2 | 0.46 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE_IPS" ] |
3 | 0.31 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE" ] |
4 | 0.33 ms |
SELECT iso_code FROM `ps_lang` WHERE id_lang = :id_lang AND active = 1
Parameters:
[ ":id_lang" => 28 ] |
5 | 5.45 ms |
SELECT cp.internal_reference, i.id_image, i.name AS image_name, pl.name, pl.description, p.price,p.wholesale_price, cp.quantity, (p.weight+ IFNULL(pa.weight, 0)) AS weight, p.width, p.height, p.depth, p.ean13, IFNULL(p.upc , "") upc, p.cache_is_pack, ROUND((sp.reduction * 100) / p.price) AS percentage_discount, sp.reduction AS money_discount, p.delay, cp.quantity AS quantity_total, p.is_virtual, p.id_category_default, p.active, p.reference AS parent_reference, cp.id_product, cp.id_product_attribute, cp.id_cart_product, sp.reduction, cp.future_stock, cp.purchase_order, cp.id_purchase_line, GROUP_CONCAT(DISTINCT a.name ORDER BY a.id_attribute SEPARATOR ", ") AS attribute_name, p.id_supplier, p.id_taxonomy_default, p.id_tax, COALESCE(t.rate, 21) AS tax_rate, COALESCE(tl.name, "IVA 20%") AS tax_name, COALESCE(pa.reference, p.reference) AS reference, cp.locks, p.id_category_default, pl.name AS default_name, txl.name AS default_category_name, p.producto_electronico, cp.extern_stock, cp.extern_stock_3_5, p.estimate_cost_price, psa.id_warehouse, pw.allow_fulfillment FROM ps_cart c LEFT JOIN ps_cart_product cp ON c.id_cart = cp.id_cart LEFT JOIN ps_product p ON p.id_product = cp.id_product LEFT JOIN ps_product_lang_cs pl ON pl.id_product = p.id_product LEFT JOIN ps_image AS i ON p.id_product = i.id_product LEFT JOIN ps_specific_price sp ON sp.id_product = p.id_product LEFT JOIN ps_product_attribute AS pa ON pa.id_product_attribute = cp.id_product_attribute LEFT JOIN ps_product_attribute_combination AS pac ON pac.id_product_attribute = cp.id_product_attribute LEFT JOIN ps_attribute AS a ON a.id_attribute = pac.id_attribute AND (a.id_lang = :id_lang OR a.id_lang IS NULL) INNER JOIN ps_stock_available AS psa ON psa.id_product = cp.id_product AND psa.id_product_attribute = cp.id_product_attribute INNER JOIN ps_warehouse AS pw ON psa.id_warehouse = pw.id LEFT JOIN ps_tax_rule AS ptr ON ptr.id_tax_rules_group = p.id_tax AND ptr.country_origin = pw.country AND ptr.id_country = :id_shipping_country LEFT JOIN ps_tax t ON t.id_tax = ptr.id_tax LEFT JOIN ps_tax_lang AS tl ON ptr.id_tax = tl.id_tax AND (tl.id_lang = :id_lang OR tl.id_lang = 1) LEFT JOIN taxonomy_lang AS txl ON txl.id_taxonomy = p.id_taxonomy_default AND (txl.id_lang = :id_lang OR txl.id_lang IS NULL) WHERE c.id_cart = :id_cart AND sp.from_quantity <= 1 AND (i.cover = 1 OR i.id_image IS NULL) GROUP BY id_cart_product ORDER BY cp.id_cart_product ASC
Parameters:
[ ":id_cart" => 0 ":id_lang" => 28 ":id_shipping_country" => 6 ] |
6 | 0.29 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "TAXONOMY_ALL_CATALOG" ] |
7 | 0.63 ms |
SELECT COUNT(*) FROM ps_service_customer WHERE id_customer = :id_customer AND id_service = :id_service AND active = 1
Parameters:
[ ":id_customer" => 0 ":id_service" => 17 ] |
8 | 0.63 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "JS_COMPRESSION" ] |
9 | 0.25 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "CSS_COMPRESSION" ] |
10 | 0.71 ms |
SELECT * FROM `ps_lang`
Parameters:
[] |
11 | 0.43 ms |
SELECT tl.name, tl.description, tl.link_rewrite, tl.meta_title, tl.meta_description, tl.meta_keywords, t.id_image FROM taxonomy_lang tl LEFT JOIN taxonomy t ON t.id = tl.id_taxonomy WHERE tl.id_lang = :id_lang AND tl.id_taxonomy = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 16059 ":id_lang" => 28 ] |
12 | 0.23 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 16059 ] |
13 | 0.19 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 16049 ] |
14 | 0.19 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 16048 ] |
15 | 0.37 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE" ] |
16 | 0.33 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
report | doctrine.dbal.report_connection |
logs | doctrine.dbal.logs_connection |
Entity Managers
Name | Service |
---|---|
auto_generate_proxy_classes | doctrine.orm.auto_generate_proxy_classes_entity_manager |
default | doctrine.orm.default_entity_manager |
report | doctrine.orm.report_entity_manager |
logs | doctrine.orm.logs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
auto_generate_proxy_classes entity manager
No loaded entities.
default entity manager
report entity manager
No loaded entities.
logs entity manager
No loaded entities.