FWR MEDIA
KissER Query Output:
Total Queries: 33
Total query Time 0.0532 Seconds.
Total Queries: 33
Slowest Query Number 1
Time: 0.0039 Seconds.
Total query Time 0.0532 Seconds.
Number: 1
Time: 0.0039 Seconds.
Query: select configuration_key as cfgKey, configuration_value as cfgValue from configuration
Number: 2
Time: 0.0017 Seconds.
Query: select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
Number: 3
Time: 0.0017 Seconds.
Query: select languages_id, name, code, image, directory from languages order by sort_order
Number: 4
Time: 0.0018 Seconds.
Query: select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Number: 5
Time: 0.0017 Seconds.
Query: select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10
Number: 6
Time: 0.0015 Seconds.
Query: select products_name from products_description where products_id = '23' and language_id = '1'
Number: 7
Time: 0.0017 Seconds.
Query: select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '18') and tr.tax_class_id = '1' group by tr.tax_priority
Number: 8
Time: 0.0024 Seconds.
Query: select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10
Number: 9
Time: 0.0019 Seconds.
Query: select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.reviews_status = 1 order by r.reviews_id desc limit 10
Number: 10
Time: 0.0026 Seconds.
Query: select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1'
Number: 11
Time: 0.0019 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 12
Time: 0.0014 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 13
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 14
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 15
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 16
Time: 0.0015 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '16' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 17
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '9' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 18
Time: 0.0015 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '6' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 19
Time: 0.0014 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '5' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 20
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '7' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 21
Time: 0.0015 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 22
Time: 0.0014 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '19' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 23
Time: 0.0014 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '18' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 24
Time: 0.0012 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '20' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 25
Time: 0.0012 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '3' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 26
Time: 0.0012 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '10' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 27
Time: 0.0013 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '13' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 28
Time: 0.0021 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '12' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 29
Time: 0.0012 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '15' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 30
Time: 0.0011 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '11' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 31
Time: 0.0015 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '14' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 32
Time: 0.0017 Seconds.
Query: select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
Number: 33
Time: 0.0013 Seconds.
Query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name