Kona Cotton / Kaufman - Nach Hersteller - Quiltstoffe Uni - Stoffe - Kona 1481 Banana

FWR MEDIA

KissER Query Output:

Total Queries: 82

Slowest Query Number 33
Time: 0.0435 Seconds.

Total query Time 0.161 Seconds.

Number: 1

Time: 0.0008 Seconds.

Query: select configuration_key as cfgKey, configuration_value as cfgValue from configuration

Number: 2

Time: 0.0006 Seconds.

Query: select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

Number: 3

Time: 0.0005 Seconds.

Query: select languages_id, name, code, image, directory from languages order by sort_order

Number: 4

Time: 0.0011 Seconds.

Query: SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM categories c LEFT JOIN categories_description cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = 2, categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = 435 AND cd.language_id = 2

Number: 5

Time: 0.0008 Seconds.

Query: delete from whos_online where time_last_click < '1550692388'

Number: 6

Time: 0.0009 Seconds.

Query: select count(*) as count from whos_online where session_id = ''

Number: 7

Time: 0.0008 Seconds.

Query: update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '172.16.50.221', time_last_click = '1550693288', last_page_url = '/shop/index.php/nach-hersteller/kona-cotton-kaufman-c-307_431_434_435' where session_id = ''

Number: 8

Time: 0.0009 Seconds.

Query: select banners_id, date_scheduled from banners where date_scheduled != ''

Number: 9

Time: 0.0004 Seconds.

Query: select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

Number: 10

Time: 0.0016 Seconds.

Query: select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

Number: 11

Time: 0.0005 Seconds.

Query: select categories_name from categories_description where categories_id = '307' and language_id = '2'

Number: 12

Time: 0.0005 Seconds.

Number: 13

Time: 0.0006 Seconds.

Query: select categories_name from categories_description where categories_id = '431' and language_id = '2'

Number: 14

Time: 0.0007 Seconds.

Number: 15

Time: 0.0005 Seconds.

Query: select categories_name from categories_description where categories_id = '434' and language_id = '2'

Number: 16

Time: 0.0006 Seconds.

Number: 17

Time: 0.0005 Seconds.

Query: select categories_name from categories_description where categories_id = '435' and language_id = '2'

Number: 18

Time: 0.0033 Seconds.

Query: select count(*) as total from products_to_categories where categories_id = '435'

Number: 19

Time: 0.0041 Seconds.

Query: SELECT pd.products_name FROM products_to_categories p2c LEFT JOIN products p ON p.products_id = p2c.products_id AND p.products_status = 1 LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 2 WHERE p2c.categories_id = 435 LIMIT 30

Number: 20

Time: 0.0006 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='2' order by sort_order, cd.categories_name

Number: 21

Time: 0.0005 Seconds.

Number: 22

Time: 0.0004 Seconds.

Number: 23

Time: 0.0004 Seconds.

Number: 24

Time: 0.0004 Seconds.

Number: 25

Time: 0.0004 Seconds.

Number: 26

Time: 0.0004 Seconds.

Number: 27

Time: 0.0006 Seconds.

Query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Number: 28

Time: 0.0005 Seconds.

Number: 29

Time: 0.0007 Seconds.

Query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Number: 30

Time: 0.0027 Seconds.

Query: show table status from `112206-wmaftkvvhrttnsz`

Number: 31

Time: 0.0014 Seconds.

Query: delete from products_to_categories where categories_id = '1000'

Number: 32

Time: 0.0006 Seconds.

Query: select categories_name from categories_description where categories_id = '435' and language_id = '2'

Number: 33

Time: 0.0435 Seconds.

Query: select distinct c.categories_id as id, cd.categories_name as name, c.parent_id from products p, products_to_categories p2c, products_to_categories p2c2, categories c, categories_description cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = '435' and p2c2.categories_id != '435'and p.products_id = p2c2.products_id and p2c2.categories_id = c.categories_id and cd.categories_id = c.categories_id andcd.language_id = '2'order by c.parent_id, c.sort_order

Number: 34

Time: 0.0007 Seconds.

Query: select parent_id from categories where categories_id = '431'

Number: 35

Time: 0.0004 Seconds.

Query: select parent_id from categories where categories_id = '307'

Number: 36

Time: 0.0005 Seconds.

Query: select distinct cd.categories_namefrom categories_description cd where cd.categories_id = '431' and cd.language_id = '2'

Number: 37

Time: 0.0005 Seconds.

Query: select distinct cd.categories_namefrom categories_description cd where cd.categories_id = '435' and cd.language_id = '2'

Number: 38

Time: 0.0004 Seconds.

Query: select distinct cd.categories_namefrom categories_description cd where cd.categories_id = '0' and cd.language_id = '2'

Number: 39

Time: 0.0005 Seconds.

Query: select categories_image from categories where categories_id = '435'

Number: 40

Time: 0.0261 Seconds.

Query: select count(p.products_id) as total from ((products_description pd, products p ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c ) left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '435'

Number: 41

Time: 0.0337 Seconds.

Query: select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.minorder, p.products_dim_type,IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c ) left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '435' order by pd.products_name limit 0, 200

Number: 42

Time: 0.0022 Seconds.

Query: select products_id, specials_new_products_price from specials where (products_id = '6391' or products_id = '6320' or products_id = '6323' or products_id = '5737' or products_id = '6328' or products_id = '6642' or products_id = '6643' or products_id = '5743' ) and status = '1' and customers_group_id = '0'

Number: 43

Time: 0.001 Seconds.

Query: SELECT pd.products_name, m.manufacturers_name, cd.categories_name, p.products_model, p2c.categories_id FROM products_description pd INNER JOIN products_to_categories p2c ON p2c.products_id = pd.products_id INNER JOIN products p ON pd.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id INNER JOIN categories_description cd ON p2c.categories_id = cd.categories_id AND cd.language_id='2' WHERE pd.products_id='6391' AND pd.language_id='2' LIMIT 1

Number: 44

Time: 0.0005 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 = '204') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '129') and tr.tax_class_id = '3' group by tr.tax_priority

Number: 45

Time: 0.0004 Seconds.

Number: 46

Time: 0.0007 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6391' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 47

Time: 0.0006 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6391' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 48

Time: 0.0008 Seconds.

Number: 49

Time: 0.0005 Seconds.

Number: 50

Time: 0.0004 Seconds.

Number: 51

Time: 0.0007 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6320' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 52

Time: 0.0005 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6320' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 53

Time: 0.0008 Seconds.

Number: 54

Time: 0.0005 Seconds.

Number: 55

Time: 0.0004 Seconds.

Number: 56

Time: 0.0007 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6323' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 57

Time: 0.0006 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6323' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 58

Time: 0.0008 Seconds.

Number: 59

Time: 0.0005 Seconds.

Number: 60

Time: 0.0004 Seconds.

Number: 61

Time: 0.0008 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '5737' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 62

Time: 0.0005 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='5737' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 63

Time: 0.0007 Seconds.

Number: 64

Time: 0.0005 Seconds.

Number: 65

Time: 0.0004 Seconds.

Number: 66

Time: 0.0006 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6328' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 67

Time: 0.0006 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6328' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 68

Time: 0.0007 Seconds.

Number: 69

Time: 0.0004 Seconds.

Number: 70

Time: 0.0004 Seconds.

Number: 71

Time: 0.0006 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6642' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 72

Time: 0.0006 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6642' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 73

Time: 0.0007 Seconds.

Number: 74

Time: 0.0005 Seconds.

Number: 75

Time: 0.0004 Seconds.

Number: 76

Time: 0.0007 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '6643' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 77

Time: 0.0005 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='6643' and patrib.options_id = popt.products_options_id and popt.language_id = '2'

Number: 78

Time: 0.0008 Seconds.

Number: 79

Time: 0.0005 Seconds.

Number: 80

Time: 0.0004 Seconds.

Number: 81

Time: 0.0006 Seconds.

Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_dim_type, p.minorder from products p, products_description pd where p.products_status = '1' and p.products_id = '5743' and pd.products_id = p.products_id and pd.language_id = '2'

Number: 82

Time: 0.0005 Seconds.

Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='5743' and patrib.options_id = popt.products_options_id and popt.language_id = '2'