==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 12                =
=      Total queries time: 0.00319147109985      =
==================================================

QUERY TIME 0.000646114349365
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.00037693977356
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.000353097915649
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 0.000103950500488
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 0.000113010406494
**************************************************
SELECT count(*) as total
FROM (oc_t_item_comment c, oc_t_item i)
WHERE c.fk_i_item_id = i.pk_i_id
AND ( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )
--------------------------------------------------
QUERY TIME 0.000545978546143
**************************************************
SELECT count(*) as total
FROM (oc_t_item i, oc_t_item_stats s)
WHERE i.pk_i_id = s.fk_i_item_id
AND s.i_num_spam > 0 AND i.b_spam = 0
--------------------------------------------------
QUERY TIME 0.000639200210571
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000124931335449
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000110149383545
**************************************************
SELECT *
FROM (oc_t_category_description)
WHERE fk_i_category_id = '1'
ORDER BY fk_c_locale_code
--------------------------------------------------
QUERY TIME 0.000108957290649
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 1
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.10215759277E-5
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 182               =
=      Total queries time: 0.0101044178009       =
==================================================

QUERY TIME 0.000132083892822
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000296115875244
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.000348091125488
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 0.000104904174805
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 0.000104188919067
**************************************************
SELECT count(*) as total
FROM (oc_t_item_comment c, oc_t_item i)
WHERE c.fk_i_item_id = i.pk_i_id
AND ( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )
--------------------------------------------------
QUERY TIME 8.10623168945E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item i, oc_t_item_stats s)
WHERE i.pk_i_id = s.fk_i_item_id
AND s.i_num_spam > 0 AND i.b_spam = 0
--------------------------------------------------
QUERY TIME 0.000545024871826
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000131130218506
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000223875045776
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90', b_price_enabled = 1 WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 0.000149965286255
**************************************************
update oc_t_item as a
                        left join oc_t_category  as b on b.pk_i_id = a.fk_i_category_id
                        set a.dt_expiration = date_add(a.dt_pub_date, INTERVAL b.i_expiration_days DAY)
                        where a.fk_i_category_id = 1 
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_slug = 'for-sale'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000131130218506
**************************************************
UPDATE oc_t_category_description SET s_name = 'For sale', s_description = '', fk_i_category_id = '1', fk_c_locale_code = 'en_US', s_slug = 'for-sale' WHERE fk_i_category_id = '1' AND fk_c_locale_code = 'en_US'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
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.pk_i_id = '1'
AND b.fk_c_locale_code = 'en_US'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 1
--------------------------------------------------
QUERY TIME 8.01086425781E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 1
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 9
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '38'
--------------------------------------------------
QUERY TIME 0.000109910964966
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 38
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '38'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '112'
--------------------------------------------------
QUERY TIME 0.000105142593384
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 112
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '112'
--------------------------------------------------
QUERY TIME 7.60555267334E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '9'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 9
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.121925354E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 10
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '93'
--------------------------------------------------
QUERY TIME 8.41617584229E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 93
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '93'
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '10'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 10
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 11
--------------------------------------------------
QUERY TIME 8.9168548584E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '11'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 11
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 12
--------------------------------------------------
QUERY TIME 8.70227813721E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '12'
--------------------------------------------------
QUERY TIME 2.21729278564E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 12
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 13
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '39'
--------------------------------------------------
QUERY TIME 8.20159912109E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 39
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '39'
--------------------------------------------------
QUERY TIME 9.01222229004E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '13'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 13
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 14
--------------------------------------------------
QUERY TIME 9.01222229004E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '14'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 14
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 15
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '14'
--------------------------------------------------
QUERY TIME 9.58442687988E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 14
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '14'
--------------------------------------------------
QUERY TIME 9.29832458496E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '15'
--------------------------------------------------
QUERY TIME 3.69548797607E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 15
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 16
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '22'
--------------------------------------------------
QUERY TIME 9.70363616943E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 22
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '22'
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '25'
--------------------------------------------------
QUERY TIME 9.60826873779E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 25
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '25'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '42'
--------------------------------------------------
QUERY TIME 9.20295715332E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 42
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '42'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '97'
--------------------------------------------------
QUERY TIME 9.20295715332E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 97
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '97'
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '16'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 16
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 17
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '40'
--------------------------------------------------
QUERY TIME 9.70363616943E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 40
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '40'
--------------------------------------------------
QUERY TIME 7.60555267334E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '17'
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 17
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 18
--------------------------------------------------
QUERY TIME 9.10758972168E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '18'
--------------------------------------------------
QUERY TIME 2.40802764893E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 18
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 19
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '19'
--------------------------------------------------
QUERY TIME 9.60826873779E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 19
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '19'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '41'
--------------------------------------------------
QUERY TIME 0.000105142593384
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 41
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '41'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '91'
--------------------------------------------------
QUERY TIME 9.41753387451E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 91
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '91'
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '105'
--------------------------------------------------
QUERY TIME 7.9870223999E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 105
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '105'
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '19'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 19
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.121925354E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 20
--------------------------------------------------
QUERY TIME 8.08238983154E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '20'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 20
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 21
--------------------------------------------------
QUERY TIME 9.29832458496E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '21'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 21
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 22
--------------------------------------------------
QUERY TIME 9.20295715332E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '22'
--------------------------------------------------
QUERY TIME 2.38418579102E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 22
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.21729278564E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 23
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '102'
--------------------------------------------------
QUERY TIME 8.20159912109E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 102
--------------------------------------------------
QUERY TIME 1.97887420654E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '102'
--------------------------------------------------
QUERY TIME 7.89165496826E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '23'
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 23
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 24
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '13'
--------------------------------------------------
QUERY TIME 9.48905944824E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 13
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '13'
--------------------------------------------------
QUERY TIME 8.89301300049E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '24'
--------------------------------------------------
QUERY TIME 2.40802764893E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 24
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 3.40938568115E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 25
--------------------------------------------------
QUERY TIME 8.98838043213E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '25'
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 25
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 26
--------------------------------------------------
QUERY TIME 8.82148742676E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '26'
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 26
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 27
--------------------------------------------------
QUERY TIME 8.89301300049E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '27'
--------------------------------------------------
QUERY TIME 2.40802764893E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 27
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 28
--------------------------------------------------
QUERY TIME 8.89301300049E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '28'
--------------------------------------------------
QUERY TIME 2.21729278564E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 28
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 29
--------------------------------------------------
QUERY TIME 8.29696655273E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '29'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 29
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 30
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '24'
--------------------------------------------------
QUERY TIME 8.60691070557E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 24
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '24'
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '80'
--------------------------------------------------
QUERY TIME 8.08238983154E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 80
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '80'
--------------------------------------------------
QUERY TIME 8.29696655273E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '30'
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 30
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.70227813721E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 2.98023223877E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 1
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.20159912109E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '9'
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 9
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 9.08374786377E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '10'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 10
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.10623168945E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '11'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 11
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '12'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 12
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '13'
--------------------------------------------------
QUERY TIME 2.71797180176E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 13
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '14'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 14
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '15'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 15
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.48770141602E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '16'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 16
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.89165496826E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '17'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 17
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.10623168945E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '18'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 18
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.67707824707E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '19'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 19
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.82012939453E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '20'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 20
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '21'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 21
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '22'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 22
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '23'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 23
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '24'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 24
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.9870223999E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '25'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 25
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '26'
--------------------------------------------------
QUERY TIME 2.59876251221E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 26
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '27'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 27
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.67707824707E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '28'
--------------------------------------------------
QUERY TIME 2.62260437012E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 28
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '29'
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 29
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '30'
--------------------------------------------------
QUERY TIME 2.50339508057E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 30
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 12                =
=      Total queries time: 0.00181794166565      =
==================================================

QUERY TIME 0.000121116638184
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.00028395652771
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.000297784805298
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 2.8133392334E-5
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item_comment c, oc_t_item i)
WHERE c.fk_i_item_id = i.pk_i_id
AND ( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item i, oc_t_item_stats s)
WHERE i.pk_i_id = s.fk_i_item_id
AND s.i_num_spam > 0 AND i.b_spam = 0
--------------------------------------------------
QUERY TIME 0.000473976135254
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 4.19616699219E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000123977661133
**************************************************
SELECT *
FROM (oc_t_category_description)
WHERE fk_i_category_id = '2'
ORDER BY fk_c_locale_code
--------------------------------------------------
QUERY TIME 0.000355005264282
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 2
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.40802764893E-5
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------
QUERY TIME 2.40802764893E-5
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 77                =
=      Total queries time: 0.00804495811462      =
==================================================

QUERY TIME 0.000157833099365
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000342845916748
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.000293016433716
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 5.10215759277E-5
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 0.000102996826172
**************************************************
SELECT count(*) as total
FROM (oc_t_item_comment c, oc_t_item i)
WHERE c.fk_i_item_id = i.pk_i_id
AND ( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )
--------------------------------------------------
QUERY TIME 6.38961791992E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item i, oc_t_item_stats s)
WHERE i.pk_i_id = s.fk_i_item_id
AND s.i_num_spam > 0 AND i.b_spam = 0
--------------------------------------------------
QUERY TIME 0.000491142272949
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000123023986816
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000243902206421
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90', b_price_enabled = 1 WHERE pk_i_id = '2'
--------------------------------------------------
QUERY TIME 0.000192880630493
**************************************************
update oc_t_item as a
                        left join oc_t_category  as b on b.pk_i_id = a.fk_i_category_id
                        set a.dt_expiration = date_add(a.dt_pub_date, INTERVAL b.i_expiration_days DAY)
                        where a.fk_i_category_id = 2 
--------------------------------------------------
QUERY TIME 0.000240802764893
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_slug = 'vehicles'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000159025192261
**************************************************
UPDATE oc_t_category_description SET s_name = 'Vehicles', s_description = '', fk_i_category_id = '2', fk_c_locale_code = 'en_US', s_slug = 'vehicles' WHERE fk_i_category_id = '2' AND fk_c_locale_code = 'en_US'
--------------------------------------------------
QUERY TIME 0.000181913375854
**************************************************
SELECT *
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.pk_i_id = '2'
AND b.fk_c_locale_code = 'en_US'
--------------------------------------------------
QUERY TIME 0.000159025192261
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 2
--------------------------------------------------
QUERY TIME 0.000148057937622
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '126'
--------------------------------------------------
QUERY TIME 0.000162839889526
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 126
--------------------------------------------------
QUERY TIME 7.39097595215E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '126'
--------------------------------------------------
QUERY TIME 0.000112056732178
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '2'
--------------------------------------------------
QUERY TIME 7.20024108887E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 2
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000108003616333
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 31
--------------------------------------------------
QUERY TIME 4.60147857666E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '23'
--------------------------------------------------
QUERY TIME 9.48905944824E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 23
--------------------------------------------------
QUERY TIME 7.00950622559E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '23'
--------------------------------------------------
QUERY TIME 4.48226928711E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '122'
--------------------------------------------------
QUERY TIME 8.79764556885E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 122
--------------------------------------------------
QUERY TIME 6.5803527832E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '122'
--------------------------------------------------
QUERY TIME 8.39233398438E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '31'
--------------------------------------------------
QUERY TIME 0.000186920166016
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 31
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.60283660889E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 32
--------------------------------------------------
QUERY TIME 8.70227813721E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '32'
--------------------------------------------------
QUERY TIME 0.000181913375854
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 32
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.88893890381E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 33
--------------------------------------------------
QUERY TIME 9.79900360107E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '52'
--------------------------------------------------
QUERY TIME 7.79628753662E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 52
--------------------------------------------------
QUERY TIME 6.79492950439E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '52'
--------------------------------------------------
QUERY TIME 4.50611114502E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '53'
--------------------------------------------------
QUERY TIME 9.41753387451E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 53
--------------------------------------------------
QUERY TIME 6.5803527832E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '53'
--------------------------------------------------
QUERY TIME 4.41074371338E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '125'
--------------------------------------------------
QUERY TIME 7.10487365723E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 125
--------------------------------------------------
QUERY TIME 6.60419464111E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '125'
--------------------------------------------------
QUERY TIME 6.98566436768E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '33'
--------------------------------------------------
QUERY TIME 0.000182867050171
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 33
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.57899475098E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 34
--------------------------------------------------
QUERY TIME 7.20024108887E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '34'
--------------------------------------------------
QUERY TIME 0.000180959701538
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 34
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.50746917725E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 35
--------------------------------------------------
QUERY TIME 7.20024108887E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '35'
--------------------------------------------------
QUERY TIME 0.000216960906982
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 35
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.79764556885E-5
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 36
--------------------------------------------------
QUERY TIME 0.000102996826172
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '36'
--------------------------------------------------
QUERY TIME 0.000177145004272
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 36
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000102996826172
**************************************************
SELECT pk_i_id
FROM (oc_t_item)
WHERE fk_i_category_id = 37
--------------------------------------------------
QUERY TIME 4.6968460083E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '114'
--------------------------------------------------
QUERY TIME 9.20295715332E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 114
--------------------------------------------------
QUERY TIME 6.89029693604E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '114'
--------------------------------------------------
QUERY TIME 4.50611114502E-5
**************************************************
SELECT dt_expiration
FROM (oc_t_item)
WHERE pk_i_id = '116'
--------------------------------------------------
QUERY TIME 8.79764556885E-5
**************************************************
UPDATE oc_t_item SET dt_expiration =  date_add(oc_t_item.dt_pub_date, INTERVAL 90 DAY)  WHERE pk_i_id = 116
--------------------------------------------------
QUERY TIME 6.48498535156E-5
**************************************************
SELECT i.dt_expiration, i.fk_i_user_id, i.fk_i_category_id, l.fk_c_country_code, l.fk_i_region_id, l.fk_i_city_id
FROM (oc_t_item i,  oc_t_item_location l)
WHERE i.pk_i_id = l.fk_i_item_id
AND i.pk_i_id = '116'
--------------------------------------------------
QUERY TIME 8.29696655273E-5
**************************************************
UPDATE oc_t_category SET i_expiration_days = '90' WHERE pk_i_id = '37'
--------------------------------------------------
QUERY TIME 0.000181913375854
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 37
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.70092010498E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '2'
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 2
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.20024108887E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '31'
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 31
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 8.48770141602E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '32'
--------------------------------------------------
QUERY TIME 1.69277191162E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 32
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 6.89029693604E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '33'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 33
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.20024108887E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '34'
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 34
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 6.79492950439E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '35'
--------------------------------------------------
QUERY TIME 5.00679016113E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 35
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000104188919067
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '36'
--------------------------------------------------
QUERY TIME 4.88758087158E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 36
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 6.91413879395E-5
**************************************************
UPDATE oc_t_category SET b_price_enabled = 1 WHERE pk_i_id = '37'
--------------------------------------------------
QUERY TIME 1.69277191162E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 37
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 10                =
=      Total queries time: 0.0019211769104       =
==================================================

QUERY TIME 0.000168085098267
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000247001647949
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.00034499168396
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 5.60283660889E-5
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------
QUERY TIME 9.29832458496E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item_comment c, oc_t_item i)
WHERE c.fk_i_item_id = i.pk_i_id
AND ( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )
--------------------------------------------------
QUERY TIME 9.10758972168E-5
**************************************************
SELECT count(*) as total
FROM (oc_t_item i, oc_t_item_stats s)
WHERE i.pk_i_id = s.fk_i_item_id
AND s.i_num_spam > 0 AND i.b_spam = 0
--------------------------------------------------
QUERY TIME 0.000606060028076
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000124931335449
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000128030776978
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT  JOIN oc_t_category_stats  as c  ON a.pk_i_id = c.fk_i_category_id
WHERE 1 = 1
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 6.19888305664E-5
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=               Total queries: 163               =
=      Total queries time: 0.00863122940063      =
==================================================

QUERY TIME 0.000194072723389
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.00031590461731
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 0.000105142593384
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 8.89301300049E-5
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 6.50882720947E-5
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 0.0001060962677
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 5.29289245605E-5
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM (oc_t_seopro_home)
WHERE id = 1
--------------------------------------------------
QUERY TIME 0.000102996826172
**************************************************
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
--------------------------------------------------
QUERY TIME 0.0001220703125
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.91549682617E-5
**************************************************
SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
 JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items >= 0
ORDER BY country_name ASC
--------------------------------------------------
QUERY TIME 0.000423192977905
**************************************************
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, 20
--------------------------------------------------
QUERY TIME 0.000227212905884
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (131, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000156879425049
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (130, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000180006027222
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (129, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000173091888428
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (7, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000162124633789
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (127, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000144004821777
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (3, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000139951705933
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (11, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 0.000118017196655
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (4, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 9.91821289062E-5
**************************************************
INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (5, '2018-07-25 11:08:48',1) ON DUPLICATE KEY UPDATE  i_num_premium_views = i_num_premium_views + 1 
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '131'
--------------------------------------------------
QUERY TIME 0.00012993812561
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '131'
AND s.fk_i_item_id = '131'
AND cd.fk_i_category_id = '100'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '130'
--------------------------------------------------
QUERY TIME 0.00015115737915
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '130'
AND s.fk_i_item_id = '130'
AND cd.fk_i_category_id = '100'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 4.79221343994E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '129'
--------------------------------------------------
QUERY TIME 0.000186920166016
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '129'
AND s.fk_i_item_id = '129'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '7'
--------------------------------------------------
QUERY TIME 0.000178098678589
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '7'
AND s.fk_i_item_id = '7'
AND cd.fk_i_category_id = '98'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '127'
--------------------------------------------------
QUERY TIME 0.000149965286255
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '127'
AND s.fk_i_item_id = '127'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 4.88758087158E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '3'
--------------------------------------------------
QUERY TIME 0.000179052352905
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '3'
AND s.fk_i_item_id = '3'
AND cd.fk_i_category_id = '106'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.38282775879E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '11'
--------------------------------------------------
QUERY TIME 0.00017786026001
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '11'
AND s.fk_i_item_id = '11'
AND cd.fk_i_category_id = '106'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.69277191162E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '4'
--------------------------------------------------
QUERY TIME 0.000184059143066
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '4'
AND s.fk_i_item_id = '4'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '5'
--------------------------------------------------
QUERY TIME 0.000179052352905
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '5'
AND s.fk_i_item_id = '5'
AND cd.fk_i_category_id = '101'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 5.60283660889E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 131
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 131
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 131
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 100
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
--------------------------------------------------
QUERY TIME 4.88758087158E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 130
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 130
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 100
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.48362731934E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 129
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 129
--------------------------------------------------
QUERY TIME 1.38282775879E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 129
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.00679016113E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 7
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 7
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 98
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.72204589844E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 127
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 127
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 127
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.3882598877E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 3
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 3
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 106
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000110149383545
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 11
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.4066696167E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 11
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 11
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 106
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 4.6968460083E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 6.00814819336E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 4
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 4
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 7.5101852417E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 5
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 5
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 5
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 101
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 0.000219106674194
**************************************************
SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2018-07-25 11:08:48')
ORDER BY dt_pub_date DESC
LIMIT 0, 12
--------------------------------------------------
QUERY TIME 0.000123977661133
**************************************************
SELECT oc_t_item.pk_i_id
FROM (oc_t_item)
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2018-07-25 11:08:48')
ORDER BY dt_pub_date DESC
LIMIT 1200
--------------------------------------------------
QUERY TIME 1.69277191162E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '132'
--------------------------------------------------
QUERY TIME 0.000126123428345
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '132'
AND s.fk_i_item_id = '132'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '127'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '127'
AND s.fk_i_item_id = '127'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.47819519043E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '11'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '11'
AND s.fk_i_item_id = '11'
AND cd.fk_i_category_id = '106'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '5'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '5'
AND s.fk_i_item_id = '5'
AND cd.fk_i_category_id = '101'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '3'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '3'
AND s.fk_i_item_id = '3'
AND cd.fk_i_category_id = '106'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '131'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '131'
AND s.fk_i_item_id = '131'
AND cd.fk_i_category_id = '100'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.4066696167E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '130'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '130'
AND s.fk_i_item_id = '130'
AND cd.fk_i_category_id = '100'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '129'
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '129'
AND s.fk_i_item_id = '129'
AND cd.fk_i_category_id = '97'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '126'
--------------------------------------------------
QUERY TIME 0.000123023986816
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '126'
AND s.fk_i_item_id = '126'
AND cd.fk_i_category_id = '2'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '125'
--------------------------------------------------
QUERY TIME 0.000123023986816
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '125'
AND s.fk_i_item_id = '125'
AND cd.fk_i_category_id = '33'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.38282775879E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '123'
--------------------------------------------------
QUERY TIME 0.0001220703125
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '123'
AND s.fk_i_item_id = '123'
AND cd.fk_i_category_id = '54'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '7'
--------------------------------------------------
QUERY TIME 1.8835067749E-5
**************************************************
SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '7'
AND s.fk_i_item_id = '7'
AND cd.fk_i_category_id = '98'
AND cd.fk_c_locale_code = 'en_US'
GROUP BY fk_i_item_id
--------------------------------------------------
QUERY TIME 5.10215759277E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 132
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 132
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 127
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 127
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.31266021729E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 11
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 11
--------------------------------------------------
QUERY TIME 2.47955322266E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 106
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 5
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 5
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 101
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 3
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.97887420654E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 106
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 131
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 131
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 100
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 130
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 100
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 129
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.4066696167E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 129
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 97
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.00679016113E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 126
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.62124633789E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 126
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 2
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 4.88758087158E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 125
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 125
--------------------------------------------------
QUERY TIME 6.00814819336E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 33
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '2'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 5.3882598877E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 123
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 123
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 54
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.09808349609E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '5'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'EUR'
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_upayments_colorized)
WHERE fk_i_item_id = 7
AND TIMESTAMPDIFF(DAY,dt_date,'2018-07-25 11:08:48') < 180
--------------------------------------------------
QUERY TIME 2.00271606445E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = 98
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 1.81198120117E-5
**************************************************
SELECT *
FROM ((SELECT a.*,  b.*,  c.i_num_items,  FIELD(fk_c_locale_code,  'en_US') as locale_order
FROM (oc_t_category as a)
INNER  JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
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 = '96'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
--------------------------------------------------
QUERY TIME 2.69412994385E-5
**************************************************
SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
 JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items > 0
ORDER BY country_name ASC
--------------------------------------------------
QUERY TIME 1.59740447998E-5
**************************************************
SELECT *
FROM (oc_t_widget)
WHERE s_location = 'footer1'
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_widget)
WHERE s_location = 'footer2'
--------------------------------------------------
QUERY TIME 1.50203704834E-5
**************************************************
SELECT *
FROM (oc_t_widget)
WHERE s_location = 'footer3'
--------------------------------------------------
QUERY TIME 1.90734863281E-5
**************************************************
SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
--------------------------------------------------
QUERY TIME 2.28881835938E-5
**************************************************
SELECT *
FROM (oc_t_pages_description)
WHERE fk_i_pages_id = '26'
--------------------------------------------------
QUERY TIME 1.78813934326E-5
**************************************************
SELECT *
FROM (oc_t_pages_description)
WHERE fk_i_pages_id = '27'
--------------------------------------------------
QUERY TIME 1.69277191162E-5
**************************************************
SELECT *
FROM (oc_t_pages_description)
WHERE fk_i_pages_id = '28'
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT *
FROM (oc_t_pages_description)
WHERE fk_i_pages_id = '29'
--------------------------------------------------
QUERY TIME 0.00029993057251
**************************************************
SHOW COLUMNS FROM oc_t_admin where Field = "b_moderator" 
--------------------------------------------------
QUERY TIME 2.19345092773E-5
**************************************************
SELECT pk_i_id, s_name, s_username, s_password, s_email, s_secret, b_moderator
FROM (oc_t_admin)
WHERE pk_i_id = '1'
--------------------------------------------------



==================================================
=       Date: July 25, 2018 July 25, 2018        =
=                Total queries: 5                =
=      Total queries time: 0.00114130973816      =
==================================================

QUERY TIME 0.000603199005127
**************************************************
SELECT *
FROM (oc_t_preference)
--------------------------------------------------
QUERY TIME 0.000279188156128
**************************************************
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '221', 'socialconnect', 'STRING')
--------------------------------------------------
QUERY TIME 8.9168548584E-5
**************************************************
SELECT *
FROM (oc_t_cron)
WHERE e_type = 'HOURLY'
--------------------------------------------------
QUERY TIME 8.79764556885E-5
**************************************************
SELECT *
FROM (oc_t_cron)
WHERE e_type = 'DAILY'
--------------------------------------------------
QUERY TIME 8.17775726318E-5
**************************************************
SELECT *
FROM (oc_t_cron)
WHERE e_type = 'WEEKLY'
--------------------------------------------------