Sylwester więcej / mniej opcji

1 - 1 z 1 ogłoszeń
Ogłoszenia
  • 1



  Database queries (Total queries: 22 - Total queries time: 0.29038763046265)  
0.00035405158996582 SELECT *
FROM (oglszn_t_preference)
0.00028610229492188 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oglszn_t_category as a)
INNER JOIN oglszn_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oglszn_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
0.00016903877258301 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oglszn_t_category as a)
INNER JOIN oglszn_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oglszn_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_slug = 'sylwester'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.27768802642822 SELECT f.pk_i_id
FROM (oglszn_t_meta_fields f, oglszn_t_meta_categories c)
WHERE ( c.fk_i_category_id = 62 )
AND f.pk_i_id = c.fk_i_field_id
AND f.b_searchable = 1
0.001971960067749 SELECT oglszn_t_item.*, oglszn_t_item.s_contact_name as s_user_name
FROM (oglszn_t_item)
WHERE oglszn_t_item.b_enabled = 1 AND oglszn_t_item.b_active = 1 AND oglszn_t_item.b_spam = 0 AND (oglszn_t_item.b_premium = 1 || oglszn_t_item.dt_expiration >= '2015-09-02 18:54:03')
AND oglszn_t_item.fk_i_category_id IN (62)
ORDER BY b_premium desc, dt_pub_date desc
LIMIT 0, 20
0.0018739700317383 SELECT oglszn_t_item.pk_i_id
FROM (oglszn_t_item)
WHERE oglszn_t_item.b_enabled = 1 AND oglszn_t_item.b_active = 1 AND oglszn_t_item.b_spam = 0 AND (oglszn_t_item.b_premium = 1 || oglszn_t_item.dt_expiration >= '2015-09-02 18:54:03')
AND oglszn_t_item.fk_i_category_id IN (62)
ORDER BY b_premium desc, dt_pub_date desc
LIMIT 2000
0.00059294700622559 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '479241'
0.0013270378112793 SELECT oglszn_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 (oglszn_t_item_location, oglszn_t_category_description as cd, oglszn_t_item_stats as s)
WHERE oglszn_t_item_location.fk_i_item_id = '479241'
AND s.fk_i_item_id = '479241'
AND cd.fk_i_category_id = '62'
GROUP BY fk_i_item_id
0.00014305114746094 SELECT *
FROM (oglszn_t_widget)
WHERE s_location = 'header'
0.00066614151000977 SELECT *
FROM (oglszn_t_pages)
WHERE catId = '62'
ORDER BY i_order ASC
0.00058913230895996 SELECT mf.*
FROM (oglszn_t_meta_fields mf, oglszn_t_meta_categories mc)
WHERE mc.fk_i_category_id = '62'
AND mf.pk_i_id = mc.fk_i_field_id
0.0010409355163574 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oglszn_t_category as a)
INNER JOIN oglszn_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oglszn_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = '62'
AND a.b_enabled = '1'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.000823974609375 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 479241
0.00010800361633301 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00011706352233887 SELECT *
FROM (oglszn_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0015058517456055 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oglszn_t_category as a)
INNER JOIN oglszn_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oglszn_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id IS NULL
AND pk_i_id = '62'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00069499015808105 SELECT i.fk_i_category_id, l.*, COUNT(*) AS total
FROM (oglszn_t_item as i, oglszn_t_item_location as l)
WHERE i.fk_i_category_id IN ('62')
AND i.pk_i_id = l.fk_i_item_id
AND i.b_enabled = 1
AND i.b_active = 1
AND dt_expiration >= '2015-09-02 18:54:03'
AND l.fk_i_region_id IS NOT NULL
AND l.fk_i_city_id IS NOT NULL
GROUP BY l.fk_i_region_id
0.00011515617370605 SELECT *
FROM (oglszn_t_widget)
WHERE s_location = 'footer'
9.608268737793E-5 SELECT *
FROM (oglszn_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
8.1062316894531E-5 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '25'
7.7962875366211E-5 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '26'
6.5088272094727E-5 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '27'