Koty więcej / mniej opcji

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



  Database queries (Total queries: 72 - Total queries time: 0.060053110122681)  
0.0003209114074707 SELECT *
FROM (oglszn_t_preference)
0.00030708312988281 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.00016593933105469 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 = 'koty'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0023500919342041 SELECT f.pk_i_id
FROM (oglszn_t_meta_fields f, oglszn_t_meta_categories c)
WHERE ( c.fk_i_category_id = 50 )
AND f.pk_i_id = c.fk_i_field_id
AND f.b_searchable = 1
0.0033969879150391 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-08-04 07:19:55')
AND oglszn_t_item.fk_i_category_id IN (50)
ORDER BY b_premium desc, dt_pub_date desc
LIMIT 0, 20
0.0017201900482178 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-08-04 07:19:55')
AND oglszn_t_item.fk_i_category_id IN (50)
ORDER BY b_premium desc, dt_pub_date desc
LIMIT 2000
0.0004119873046875 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '477398'
0.0014510154724121 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 = '477398'
AND s.fk_i_item_id = '477398'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.0002892017364502 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '475698'
0.0008089542388916 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 = '475698'
AND s.fk_i_item_id = '475698'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00028705596923828 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '475507'
0.00067305564880371 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 = '475507'
AND s.fk_i_item_id = '475507'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00029611587524414 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474287'
0.00073719024658203 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 = '474287'
AND s.fk_i_item_id = '474287'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.0002439022064209 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474286'
0.00046896934509277 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 = '474286'
AND s.fk_i_item_id = '474286'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00023293495178223 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474285'
0.00045394897460938 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 = '474285'
AND s.fk_i_item_id = '474285'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00023388862609863 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474284'
0.00045418739318848 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 = '474284'
AND s.fk_i_item_id = '474284'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00035190582275391 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474282'
0.0010750293731689 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 = '474282'
AND s.fk_i_item_id = '474282'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.0003359317779541 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474281'
0.00047206878662109 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 = '474281'
AND s.fk_i_item_id = '474281'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00033807754516602 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474280'
0.0010819435119629 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 = '474280'
AND s.fk_i_item_id = '474280'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00030803680419922 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474279'
0.0010390281677246 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 = '474279'
AND s.fk_i_item_id = '474279'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.0011909008026123 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474278'
0.0010440349578857 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 = '474278'
AND s.fk_i_item_id = '474278'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.0003049373626709 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474277'
0.00057792663574219 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 = '474277'
AND s.fk_i_item_id = '474277'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00027894973754883 SELECT *
FROM (oglszn_t_item_description)
WHERE oglszn_t_item_description.fk_i_item_id = '474276'
0.00062394142150879 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 = '474276'
AND s.fk_i_item_id = '474276'
AND cd.fk_i_category_id = '50'
GROUP BY fk_i_item_id
0.00012993812561035 SELECT *
FROM (oglszn_t_widget)
WHERE s_location = 'header'
0.002032995223999 SELECT *
FROM (oglszn_t_pages)
WHERE catId = '50'
ORDER BY i_order ASC
0.00081896781921387 SELECT mf.*
FROM (oglszn_t_meta_fields mf, oglszn_t_meta_categories mc)
WHERE mc.fk_i_category_id = '50'
AND mf.pk_i_id = mc.fk_i_field_id
0.003849983215332 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 = '50'
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.002453088760376 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 477398
0.00014495849609375 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
8.0108642578125E-5 SELECT *
FROM (oglszn_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0012500286102295 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 475698
0.0011410713195801 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 475507
0.00094199180603027 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474287
0.00020003318786621 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.0006561279296875 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474286
0.00020194053649902 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.0079460144042969 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474285
0.00015807151794434 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00057816505432129 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474284
0.00014591217041016 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.0005800724029541 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474282
0.00016903877258301 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.0006101131439209 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474281
0.00015997886657715 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00072693824768066 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474280
0.00013899803161621 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00050711631774902 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474279
0.00013399124145508 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00073790550231934 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474278
0.00013208389282227 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00056910514831543 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474277
0.00013089179992676 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.00063109397888184 SELECT *
FROM (oglszn_t_item_resource)
WHERE fk_i_item_id = 474276
0.0036900043487549 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oglszn_t_currency)
WHERE pk_c_code = ''
0.0015010833740234 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 = '50'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0018420219421387 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 ('50')
AND i.pk_i_id = l.fk_i_item_id
AND i.b_enabled = 1
AND i.b_active = 1
AND dt_expiration >= '2015-08-04 07:19:55'
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.00017905235290527 SELECT *
FROM (oglszn_t_widget)
WHERE s_location = 'footer'
0.00016188621520996 SELECT *
FROM (oglszn_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
0.00013899803161621 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '25'
0.00014400482177734 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '26'
0.00011301040649414 SELECT *
FROM (oglszn_t_pages_description)
WHERE fk_i_pages_id = '27'