Database queries (Total queries: 49 - Total queries time: 0.055255174636841)
0.0024638175964355 SELECT *
FROM (oc_t_preference)
0.00080108642578125 SELECT pk_c_code, s_name, s_short_name, s_description, s_version, s_author_name, s_author_url, s_currency_format, s_dec_point, s_thousands_sep, i_num_dec, s_date_format, s_stop_words, b_enabled, b_enabled_bo, b_locations_native
FROM (oc_t_locale)
WHERE pk_c_code = 'fr_FR'
0.0021061897277832 SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator"
0.00034117698669434 SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, i_login_fails, dt_login_fail_date, b_moderator, s_moderator_access
FROM (oc_t_admin)
WHERE pk_i_id = '1'
0.00089502334594727 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 0
0.00077986717224121 SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premium = 1 || i.dt_expiration >= '2020-12-21 12:07:05' )
0.0002448558807373 SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premium = 1 || i.dt_expiration >= '2020-12-21 12:07:05' )
0.00021696090698242 SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premium = 1 || i.dt_expiration >= '2020-12-21 12:07:05' )
0.00025010108947754 SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premium = 1 || i.dt_expiration >= '2020-12-21 12:07:05' )
0.00035405158996582 SELECT pk_c_code, s_name, s_name_native, s_phone_code, s_currency, s_slug
FROM (oc_t_country)
ORDER BY s_name ASC
0.00025010108947754 SELECT pk_c_code, s_name, s_name_native, s_phone_code, s_currency, s_slug
FROM (oc_t_country)
ORDER BY s_name ASC
0.0019710063934326 SELECT pk_i_id, fk_c_country_code, s_name, s_name_native, b_active, s_slug
FROM (oc_t_region)
ORDER BY s_name ASC
0.0022180080413818 SELECT a.*, b.*, c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "fr_FR")
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_name != '' AND a.b_enabled = 1
ORDER BY i_position ASC
0.002047061920166 SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE b.s_name != '' AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC
0.00044894218444824 SELECT a.*, b.*, c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "fr_FR")
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE a.fk_i_parent_id IS NOT NULL AND a.pk_i_id = 0
ORDER BY i_position ASC
0.00019502639770508 SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE a.fk_i_parent_id IS NOT NULL AND a.pk_i_id = 0
GROUP BY a.pk_i_id
ORDER BY i_position ASC
0.00037884712219238 SELECT a.*, b.*, c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "fr_FR")
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE a.fk_i_parent_id = 0 AND a.b_enabled = 1
ORDER BY i_position ASC
0.00080204010009766 SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE a.fk_i_parent_id = 0 AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC
0.00034785270690918 SELECT a.*, b.*, c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "fr_FR")
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE a.fk_i_parent_id = 0 AND a.b_enabled = 1
ORDER BY i_position ASC
0.00075101852416992 SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE a.fk_i_parent_id = 0 AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC
0.00027084350585938 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 98;
0.00017809867858887 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 122;
0.00018596649169922 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 121;
0.00017094612121582 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 125;
0.00018882751464844 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 120;
0.00018310546875 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 123;
0.00018882751464844 SELECT * FROM oc_t_category_alpha s WHERE fk_i_category_id = 126;
0.00023603439331055 SELECT *
FROM (oc_t_widget)
WHERE s_location = 'header'
0.015762090682983 SELECT oc_t_item.*
FROM (oc_t_item use index (PRIMARY), (select oc_t_item.pk_i_id FROM oc_t_item, oc_t_item_resource WHERE oc_t_item_resource.s_content_type LIKE '%image%' AND oc_t_item.pk_i_id = oc_t_item_resource.fk_i_item_id AND oc_t_item.b_active = 1 AND oc_t_item.b_enabled = 1 AND oc_t_item.b_spam = 0 AND oc_t_item.b_premium = 1 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2020-12-21 12:07:05') GROUP BY oc_t_item.pk_i_id ORDER BY oc_t_item.dt_pub_date DESC LIMIT 12) AS LIM)
WHERE oc_t_item.pk_i_id = LIM.pk_i_id
GROUP BY oc_t_item.pk_i_id
ORDER BY RAND()
LIMIT 12
0.0012547969818115 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
WHERE oc_t_item_stats.fk_i_item_id = oc_t_item.pk_i_id
AND oc_t_item.b_premium = 1
AND oc_t_item.b_enabled = 1
AND oc_t_item.b_active = 1
AND oc_t_item.b_spam = 0
GROUP BY oc_t_item.pk_i_id
ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND()
LIMIT 0, 12
0.00066113471984863 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.001676082611084 SELECT DISTINCT b.*, bl.s_title, bl.s_subtitle, bl.s_description, bl.s_seo_title, bl.s_seo_description, bl.fk_c_locale_code
FROM (oc_t_blog as b)
LEFT OUTER JOIN oc_t_blog_locale as bl ON (bl.fk_i_blog_id = b.pk_i_id AND bl.fk_c_locale_code = "fr_FR")
WHERE b.i_status > 0
ORDER BY b.i_order ASC, b.dt_pub_date DESC
LIMIT 5
0.0003669261932373 SELECT *
FROM (oc_t_blog_locale)
WHERE fk_i_blog_id = '1'
0.00045013427734375 SELECT count(*) as i_count
FROM (oc_t_blog_comment as c)
WHERE c.fk_i_blog_id = '1'
AND c.b_enabled = 1
0.00017309188842773 SELECT *
FROM (oc_t_blog as b)
WHERE b.pk_i_id = 0
0.00016593933105469 SELECT *
FROM (oc_t_blog as b)
WHERE b.pk_i_id = 0
0.00032711029052734 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00083589553833008 SELECT DISTINCT c.*, cl.s_name, cl.s_description, cl.fk_c_locale_code
FROM (oc_t_blog_category as c)
LEFT OUTER JOIN oc_t_blog_category_locale as cl ON (cl.fk_i_category_id = c.pk_i_id AND cl.fk_c_locale_code = "fr_FR")
WHERE c.pk_i_id = '1'
0.00035405158996582 SELECT *
FROM (oc_t_blog_category_locale)
WHERE fk_i_category_id = '1'
0.00020408630371094 SELECT count(*) as i_count
FROM (oc_t_blog as b)
WHERE b.i_category = '1'
0.00027799606323242 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00034403800964355 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
ORDER BY i_order ASC
LIMIT 5
0.00036215782165527 SELECT *
FROM (oc_t_pages_description)
WHERE fk_i_pages_id = '24'
0.00027894973754883 SELECT pk_i_id
FROM (oc_t_poll)
WHERE b_active = 1
0.00023007392883301 SELECT pk_i_id
FROM (oc_t_poll)
WHERE b_active = 1
0 Error number: 1064
Error description: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ((0 > 0 AND i_user_id = 0) OR (i_cookie_id = "96408961551"))' at line 4
SELECT *
FROM (oc_t_poll_result)
WHERE fk_i_poll_id =
AND ((0 > 0 AND i_user_id = 0) OR (i_cookie_id = "96408961551"))
0.011107921600342 INSERT INTO oc_t_category_alpha (fk_i_category_id)
SELECT c.pk_i_id FROM oc_t_category c WHERE c.pk_i_id NOT IN (SELECT d.fk_i_category_id FROM oc_t_category_alpha d)
0.00033307075500488 SELECT pk_c_code, s_name, s_name_native, s_phone_code, s_currency, s_slug
FROM (oc_t_country)
ORDER BY s_name ASC
0.00062394142150879