Query Metrics
90
Database Queries
24
Different statements
58.81 ms
Query time
7
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.57 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:
[
"ro"
]
|
2 | 0.34 ms |
SELECT DATABASE()
Parameters:
[] |
3 | 1.02 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:
[ "decoratiune-interioara-decor-de-sezon.html" 14 ] |
4 | 0.34 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:
[
5752
]
|
5 | 0.42 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:
[ 14 5752 ] |
6 | 1.11 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:
[
5752
]
|
7 | 0.40 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:
[
5684
]
|
8 | 0.48 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:
[
5684
]
|
9 | 0.31 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:
[
19656
]
|
10 | 0.39 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:
[
19656
]
|
11 | 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 = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 5752 1 ] |
12 | 0.42 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:
[] |
13 | 0.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 = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 5752 4 ] |
14 | 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:
[ 5752 5 ] |
15 | 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:
[ 5752 6 ] |
16 | 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:
[ 5752 7 ] |
17 | 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:
[ 5752 8 ] |
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:
[ 5752 9 ] |
19 | 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:
[ 5752 10 ] |
20 | 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:
[ 5752 11 ] |
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:
[ 5752 12 ] |
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:
[ 5752 13 ] |
23 | 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:
[ 5752 14 ] |
24 | 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:
[ 5752 15 ] |
25 | 0.22 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:
[ 5752 16 ] |
26 | 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:
[ 5752 18 ] |
27 | 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:
[ 5752 19 ] |
28 | 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:
[ 5752 20 ] |
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:
[ 5752 21 ] |
30 | 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:
[ 5752 22 ] |
31 | 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:
[ 5752 24 ] |
32 | 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:
[ 5752 25 ] |
33 | 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:
[ 5752 26 ] |
34 | 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:
[ 5752 27 ] |
35 | 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:
[ 5752 28 ] |
36 | 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:
[ 5752 14 ] |
37 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
38 | 0.50 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 14 null null null null null null null null "2025-02-26 17:03:42" null null 1 ] |
39 | 8.51 ms |
"COMMIT"
Parameters:
[] |
40 | 0.73 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:
[
"ro"
]
|
41 | 0.50 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:
[
"ro"
]
|
42 | 1.28 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:
[ 14 1 1 ] |
43 | 7.02 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:
[] |
44 | 3.45 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:
[
"decoratiune-interioara-decor-de-sezon.html"
]
|
45 | 0.45 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:
[] |
46 | 0.70 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:
[ 5752 1 ] |
47 | 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:
[ 5752 4 ] |
48 | 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:
[ 5752 5 ] |
49 | 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:
[ 5752 6 ] |
50 | 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:
[ 5752 7 ] |
51 | 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:
[ 5752 8 ] |
52 | 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:
[ 5752 9 ] |
53 | 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:
[ 5752 10 ] |
54 | 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:
[ 5752 11 ] |
55 | 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:
[ 5752 12 ] |
56 | 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:
[ 5752 13 ] |
57 | 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:
[ 5752 14 ] |
58 | 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:
[ 5752 15 ] |
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:
[ 5752 16 ] |
60 | 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:
[ 5752 18 ] |
61 | 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:
[ 5752 19 ] |
62 | 0.22 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:
[ 5752 20 ] |
63 | 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:
[ 5752 21 ] |
64 | 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:
[ 5752 22 ] |
65 | 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:
[ 5752 24 ] |
66 | 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:
[ 5752 25 ] |
67 | 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:
[ 5752 26 ] |
68 | 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:
[ 5752 27 ] |
69 | 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:
[ 5752 28 ] |
70 | 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"
]
|
71 | 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:
[
"ro"
]
|
72 | 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 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"ro"
]
|
73 | 1.09 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:
[ 14 2 1 ] |
74 | 0.33 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.59 ms |
SELECT * FROM `ps_lang` WHERE iso_code = :iso_code AND active = 1
Parameters:
[ ":iso_code" => "ro" ] |
2 | 0.32 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE_IPS" ] |
3 | 0.27 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE" ] |
4 | 0.23 ms |
SELECT iso_code FROM `ps_lang` WHERE id_lang = :id_lang AND active = 1
Parameters:
[ ":id_lang" => 14 ] |
5 | 8.01 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_ro 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" => 14 ":id_shipping_country" => 6 ] |
6 | 0.39 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "TAXONOMY_ALL_CATALOG" ] |
7 | 0.52 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.64 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "JS_COMPRESSION" ] |
9 | 0.37 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "CSS_COMPRESSION" ] |
10 | 0.92 ms |
SELECT * FROM `ps_lang`
Parameters:
[] |
11 | 0.50 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" => 5752 ":id_lang" => 14 ] |
12 | 0.24 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 5752 ] |
13 | 0.22 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 5684 ] |
14 | 0.20 ms |
SELECT id_parent FROM taxonomy WHERE id = :id_taxonomy
Parameters:
[ ":id_taxonomy" => 19656 ] |
15 | 0.28 ms |
SELECT value FROM ps_configuration WHERE name = :name
Parameters:
[ ":name" => "MAINTENANCE" ] |
16 | 0.25 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.