Volejte +420 732 241 982 (Po-Pá 8-17h)

Nezarazene hdx

 


Array ( [0] => select configuration_key as cfgkey, configuration_value as cfgvalue from zs_configuration [1] => select configuration_key as cfgkey, configuration_value as cfgvalue from zs_product_type_layout [2] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from zs_currencies [3] => select languages_id, name, code, image, directory from zs_languages order by sort_order [4] => select template_dir from zs_template_select where template_language = 0 [5] => select template_dir from zs_template_select where template_language = '1' [6] => select code from zs_currencies where code = 'CZK' LIMIT 1 [7] => delete from zs_whos_online where time_last_click < '1495570438' [8] => select count(*) as count from zs_whos_online where session_id = '' and ip_address='54.196.107.247' [9] => update zs_whos_online set customer_id = '0', full_name = '¥Spider', ip_address = '54.196.107.247', time_last_click = '1495571338', last_page_url = '/dum-firma-a-zahrada-71/nezarazene-hdx-647/index-325.html', host_address = 'ec2-54-196-107-247.compute-1.amazonaws.com', user_agent = 'CCBot/2.0 (http://commoncrawl.org/faq/)' where session_id = '' and ip_address='54.196.107.247' [10] => select banners_id, date_scheduled from zs_banners where date_scheduled != 'NULL' [11] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from zs_banners b, zs_banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions [12] => select specials_id, products_id from zs_specials where status = '0' and (((specials_date_available <= 20170523 and specials_date_available != '0001-01-01') and (expires_date > 20170523)) or ((specials_date_available <= 20170523 and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (specials_date_available = '0001-01-01' and expires_date > 20170523)) [13] => select specials_id, products_id from zs_specials where status = '1' and (20170523 < specials_date_available and specials_date_available != '0001-01-01') [14] => select specials_id, products_id from zs_specials where status = '1' and ((20170523 >= expires_date and expires_date != '0001-01-01') or (20170523 < specials_date_available and specials_date_available != '0001-01-01')) [15] => select featured_id from zs_featured where status = '0' and (((featured_date_available <= 20170523 and featured_date_available != '0001-01-01') and (expires_date > 20170523)) or ((featured_date_available <= 20170523 and featured_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (featured_date_available = '0001-01-01' and expires_date > 20170523)) [16] => select featured_id from zs_featured where status = '1' and (20170523 < featured_date_available and featured_date_available != '0001-01-01') [17] => select featured_id from zs_featured where status = '1' and ((20170523 >= expires_date and expires_date != '0001-01-01') or (20170523 < featured_date_available and featured_date_available != '0001-01-01')) [18] => select sale_id from zs_salemaker_sales where sale_status = '0' and (((sale_date_start <= 20170523 and sale_date_start != '0001-01-01') and (sale_date_end > 20170523)) or ((sale_date_start <= 20170523 and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01')) or (sale_date_start = '0001-01-01' and sale_date_end > 20170523)) [19] => select sale_id from zs_salemaker_sales where sale_status = '1' and (20170523 < sale_date_start and sale_date_start != '0001-01-01') [20] => select sale_id from zs_salemaker_sales where sale_status = '1' and ((20170523 >= sale_date_end and sale_date_end != '0001-01-01') or (20170523 < sale_date_start and sale_date_start != '0001-01-01')) [21] => select categories_name from zs_categories_description where categories_id = '71' and language_id = '1' [22] => select categories_name from zs_categories_description where categories_id = '647' and language_id = '1' [23] => select * from zs_get_terms_to_filter [24] => SELECT project_version_major, project_version_minor FROM zs_project_version WHERE project_version_key = 'Zen-Cart Database' [25] => select categories_name from zs_categories_description where categories_id = '71' and language_id = '1' [26] => select categories_name from zs_categories_description where categories_id = '647' and language_id = '1' [27] => select * from zs_get_terms_to_filter [28] => SELECT count(*) AS total FROM zs_products_to_categories WHERE categories_id = 647 [29] => select distinct m.manufacturers_id as id, m.manufacturers_name as name from zs_products p, zs_products_to_categories p2c, zs_manufacturers m where p.products_status = 1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '647' order by m.manufacturers_name [30] => select p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zs_products_description pd, zs_products p left join zs_manufacturers m on p.manufacturers_id = m.manufacturers_id, zs_products_to_categories p2c left join zs_specials s on p2c.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 = '1' and p2c.categories_id = '647' [31] => select cd.categories_name from zs_categories c, zs_categories_description cd where c.parent_id = 0 and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1 [32] => select * from zs_meta_tags_categories_description mcd where mcd.categories_id = '647' and mcd.language_id = '1' [33] => select cd.categories_name from zs_categories c, zs_categories_description cd where c.categories_id = cd.categories_id and cd.categories_id = '647' and cd.language_id = '1' and c.categories_status=1 [34] => select * from zs_categories where categories_status='1' LIMIT 1 [35] => select c.categories_id, cd.categories_name, c.parent_id from zs_categories c, zs_categories_description cd where c.categories_id = cd.categories_id and c.categories_status=1 and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name [36] => select * from zs_ezpages where status_header='1' and languages_id = 1 [37] => select * from zs_ezpages where status_header = 1 order by header_sort_order, pages_title [38] => select * from zs_manufacturers ORDER BY RAND() LIMIT 1 [39] => select * from zs_manufacturers as m join zs_manufacturers_info as mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = 1 [40] => select * from zs_ezpages where status_header='1' and languages_id = 1 [41] => select * from zs_ezpages where status_header = 1 order by header_sort_order, pages_title [42] => select * from zs_manufacturers ORDER BY RAND() LIMIT 1 [43] => select * from zs_manufacturers as m join zs_manufacturers_info as mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = 1 [44] => select * from zs_categories where categories_status='1' LIMIT 1 [45] => select c.categories_id, cd.categories_name, c.parent_id from zs_categories c, zs_categories_description cd where c.categories_id = cd.categories_id and c.categories_status=1 and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name [46] => select * from zs_ezpages where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title [47] => select *, s.products_price as slide_price, p.products_price as products_price from zs_mozen_slider as s left join zs_products as p on s.products_id=p.products_id order by s.sort_id [48] => select distinct m.manufacturers_id as id, m.manufacturers_name as name from zs_products p, zs_products_to_categories p2c, zs_manufacturers m where p.products_status = 1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '647' order by m.manufacturers_name [49] => SELECT categories_description FROM zs_categories_description WHERE categories_id= 647 AND language_id = 1 [50] => select categories_image from zs_categories where categories_id= '647' [51] => select p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zs_products_description pd, zs_products p left join zs_manufacturers m on p.manufacturers_id = m.manufacturers_id, zs_products_to_categories p2c left join zs_specials s on p2c.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 = '1' and p2c.categories_id = '647' order by p.products_sort_order, p.products_sklad desc, p.products_quantity desc, pd.products_name [52] => select count(p.products_id) as total from zs_products_description pd, zs_products p left join zs_manufacturers m on p.manufacturers_id = m.manufacturers_id, zs_products_to_categories p2c left join zs_specials s on p2c.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 = '1' and p2c.categories_id = '647' [53] => select p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zs_products_description pd, zs_products p left join zs_manufacturers m on p.manufacturers_id = m.manufacturers_id, zs_products_to_categories p2c left join zs_specials s on p2c.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 = '1' and p2c.categories_id = '647' order by p.products_sort_order, p.products_sklad desc, p.products_quantity desc, pd.products_name limit 3888, 12 [54] => select products_type from zs_products where products_id = '129981' [55] => select type_handler from zs_product_types where type_id = '1' [56] => select parent_id from zs_categories where categories_id = '71' [57] => select products_description from zs_products_description where products_id = '129981' and language_id = '1' [58] => select products_type from zs_products where products_id = '129981' [59] => select type_handler from zs_product_types where type_id = '1' [60] => select parent_id from zs_categories where categories_id = '71' [61] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '129981' limit 1 [62] => select products_price, products_priced_by_attribute from zs_products where products_id = '129981' [63] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '129981' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [64] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '129981' [65] => select products_price, products_priced_by_attribute from zs_products where products_id = '129981' [66] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '129981' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [67] => select specials_new_products_price from zs_specials where products_id = '129981' and status='1' [68] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '129981' [69] => select products_price, products_priced_by_attribute from zs_products where products_id = '129981' [70] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '129981' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [71] => select specials_new_products_price from zs_specials where products_id = '129981' and status='1' [72] => select master_categories_id from zs_products where products_id = '129981' [73] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '1280.9900' or sale_pricerange_from = '0') and (sale_pricerange_to >= '1280.9900' or sale_pricerange_to = '0') [74] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [75] => select products_type from zs_products where products_id = '129981' [76] => select type_handler from zs_product_types where type_id = '1' [77] => select parent_id from zs_categories where categories_id = '71' [78] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '129981' limit 1 [79] => select products_type from zs_products where products_id='129981' [80] => select allow_add_to_cart from zs_product_types where type_id = '1' [81] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '129981' [82] => select products_type from zs_products where products_id='129981' [83] => select allow_add_to_cart from zs_product_types where type_id = '1' [84] => select products_id, products_quantity_order_min from zs_products where products_id = '129981' [85] => select products_id, products_quantity_order_units from zs_products where products_id = '129981' [86] => select products_id, products_quantity_order_max from zs_products where products_id = '129981' [87] => select products_type from zs_products where products_id='129981' [88] => select type_handler from zs_product_types where type_id = '1' [89] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [90] => select products_type from zs_products where products_id = '126333' [91] => select type_handler from zs_product_types where type_id = '1' [92] => select parent_id from zs_categories where categories_id = '71' [93] => select products_description from zs_products_description where products_id = '126333' and language_id = '1' [94] => select products_type from zs_products where products_id = '126333' [95] => select type_handler from zs_product_types where type_id = '1' [96] => select parent_id from zs_categories where categories_id = '71' [97] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '126333' limit 1 [98] => select products_price, products_priced_by_attribute from zs_products where products_id = '126333' [99] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '126333' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [100] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '126333' [101] => select products_price, products_priced_by_attribute from zs_products where products_id = '126333' [102] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '126333' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [103] => select specials_new_products_price from zs_specials where products_id = '126333' and status='1' [104] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '126333' [105] => select products_price, products_priced_by_attribute from zs_products where products_id = '126333' [106] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '126333' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [107] => select specials_new_products_price from zs_specials where products_id = '126333' and status='1' [108] => select master_categories_id from zs_products where products_id = '126333' [109] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '185.9500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '185.9500' or sale_pricerange_to = '0') [110] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [111] => select products_type from zs_products where products_id = '126333' [112] => select type_handler from zs_product_types where type_id = '1' [113] => select parent_id from zs_categories where categories_id = '71' [114] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '126333' limit 1 [115] => select products_type from zs_products where products_id='126333' [116] => select allow_add_to_cart from zs_product_types where type_id = '1' [117] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '126333' [118] => select products_type from zs_products where products_id='126333' [119] => select allow_add_to_cart from zs_product_types where type_id = '1' [120] => select products_id, products_quantity_order_min from zs_products where products_id = '126333' [121] => select products_id, products_quantity_order_units from zs_products where products_id = '126333' [122] => select products_id, products_quantity_order_max from zs_products where products_id = '126333' [123] => select products_type from zs_products where products_id='126333' [124] => select type_handler from zs_product_types where type_id = '1' [125] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [126] => select products_type from zs_products where products_id = '55730' [127] => select type_handler from zs_product_types where type_id = '1' [128] => select parent_id from zs_categories where categories_id = '71' [129] => select products_description from zs_products_description where products_id = '55730' and language_id = '1' [130] => select products_type from zs_products where products_id = '55730' [131] => select type_handler from zs_product_types where type_id = '1' [132] => select parent_id from zs_categories where categories_id = '71' [133] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '55730' limit 1 [134] => select products_price, products_priced_by_attribute from zs_products where products_id = '55730' [135] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '55730' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [136] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '55730' [137] => select products_price, products_priced_by_attribute from zs_products where products_id = '55730' [138] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '55730' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [139] => select specials_new_products_price from zs_specials where products_id = '55730' and status='1' [140] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '55730' [141] => select products_price, products_priced_by_attribute from zs_products where products_id = '55730' [142] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '55730' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [143] => select specials_new_products_price from zs_specials where products_id = '55730' and status='1' [144] => select master_categories_id from zs_products where products_id = '55730' [145] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '71.8190' or sale_pricerange_from = '0') and (sale_pricerange_to >= '71.8190' or sale_pricerange_to = '0') [146] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [147] => select products_type from zs_products where products_id = '55730' [148] => select type_handler from zs_product_types where type_id = '1' [149] => select parent_id from zs_categories where categories_id = '71' [150] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '55730' limit 1 [151] => select products_type from zs_products where products_id='55730' [152] => select allow_add_to_cart from zs_product_types where type_id = '1' [153] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '55730' [154] => select products_type from zs_products where products_id='55730' [155] => select allow_add_to_cart from zs_product_types where type_id = '1' [156] => select products_id, products_quantity_order_min from zs_products where products_id = '55730' [157] => select products_id, products_quantity_order_units from zs_products where products_id = '55730' [158] => select products_id, products_quantity_order_max from zs_products where products_id = '55730' [159] => select products_type from zs_products where products_id='55730' [160] => select type_handler from zs_product_types where type_id = '1' [161] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [162] => select products_type from zs_products where products_id = '107044' [163] => select type_handler from zs_product_types where type_id = '1' [164] => select parent_id from zs_categories where categories_id = '71' [165] => select products_description from zs_products_description where products_id = '107044' and language_id = '1' [166] => select products_type from zs_products where products_id = '107044' [167] => select type_handler from zs_product_types where type_id = '1' [168] => select parent_id from zs_categories where categories_id = '71' [169] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '107044' limit 1 [170] => select products_price, products_priced_by_attribute from zs_products where products_id = '107044' [171] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '107044' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [172] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '107044' [173] => select products_price, products_priced_by_attribute from zs_products where products_id = '107044' [174] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '107044' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [175] => select specials_new_products_price from zs_specials where products_id = '107044' and status='1' [176] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '107044' [177] => select products_price, products_priced_by_attribute from zs_products where products_id = '107044' [178] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '107044' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [179] => select specials_new_products_price from zs_specials where products_id = '107044' and status='1' [180] => select master_categories_id from zs_products where products_id = '107044' [181] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '28.9300' or sale_pricerange_from = '0') and (sale_pricerange_to >= '28.9300' or sale_pricerange_to = '0') [182] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [183] => select products_type from zs_products where products_id = '107044' [184] => select type_handler from zs_product_types where type_id = '1' [185] => select parent_id from zs_categories where categories_id = '71' [186] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '107044' limit 1 [187] => select products_type from zs_products where products_id='107044' [188] => select allow_add_to_cart from zs_product_types where type_id = '1' [189] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '107044' [190] => select products_type from zs_products where products_id='107044' [191] => select allow_add_to_cart from zs_product_types where type_id = '1' [192] => select products_id, products_quantity_order_min from zs_products where products_id = '107044' [193] => select products_id, products_quantity_order_units from zs_products where products_id = '107044' [194] => select products_id, products_quantity_order_max from zs_products where products_id = '107044' [195] => select products_type from zs_products where products_id='107044' [196] => select type_handler from zs_product_types where type_id = '1' [197] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [198] => select products_type from zs_products where products_id = '112300' [199] => select type_handler from zs_product_types where type_id = '1' [200] => select parent_id from zs_categories where categories_id = '71' [201] => select products_description from zs_products_description where products_id = '112300' and language_id = '1' [202] => select products_type from zs_products where products_id = '112300' [203] => select type_handler from zs_product_types where type_id = '1' [204] => select parent_id from zs_categories where categories_id = '71' [205] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '112300' limit 1 [206] => select products_price, products_priced_by_attribute from zs_products where products_id = '112300' [207] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '112300' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [208] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '112300' [209] => select products_price, products_priced_by_attribute from zs_products where products_id = '112300' [210] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '112300' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [211] => select specials_new_products_price from zs_specials where products_id = '112300' and status='1' [212] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '112300' [213] => select products_price, products_priced_by_attribute from zs_products where products_id = '112300' [214] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '112300' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [215] => select specials_new_products_price from zs_specials where products_id = '112300' and status='1' [216] => select master_categories_id from zs_products where products_id = '112300' [217] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '73.5500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '73.5500' or sale_pricerange_to = '0') [218] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [219] => select products_type from zs_products where products_id = '112300' [220] => select type_handler from zs_product_types where type_id = '1' [221] => select parent_id from zs_categories where categories_id = '71' [222] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '112300' limit 1 [223] => select products_type from zs_products where products_id='112300' [224] => select allow_add_to_cart from zs_product_types where type_id = '1' [225] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '112300' [226] => select products_type from zs_products where products_id='112300' [227] => select allow_add_to_cart from zs_product_types where type_id = '1' [228] => select products_id, products_quantity_order_min from zs_products where products_id = '112300' [229] => select products_id, products_quantity_order_units from zs_products where products_id = '112300' [230] => select products_id, products_quantity_order_max from zs_products where products_id = '112300' [231] => select products_type from zs_products where products_id='112300' [232] => select type_handler from zs_product_types where type_id = '1' [233] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [234] => select products_type from zs_products where products_id = '132776' [235] => select type_handler from zs_product_types where type_id = '1' [236] => select parent_id from zs_categories where categories_id = '71' [237] => select products_description from zs_products_description where products_id = '132776' and language_id = '1' [238] => select products_type from zs_products where products_id = '132776' [239] => select type_handler from zs_product_types where type_id = '1' [240] => select parent_id from zs_categories where categories_id = '71' [241] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '132776' limit 1 [242] => select products_price, products_priced_by_attribute from zs_products where products_id = '132776' [243] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '132776' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [244] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '132776' [245] => select products_price, products_priced_by_attribute from zs_products where products_id = '132776' [246] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '132776' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [247] => select specials_new_products_price from zs_specials where products_id = '132776' and status='1' [248] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '132776' [249] => select products_price, products_priced_by_attribute from zs_products where products_id = '132776' [250] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '132776' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [251] => select specials_new_products_price from zs_specials where products_id = '132776' and status='1' [252] => select master_categories_id from zs_products where products_id = '132776' [253] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '36.3600' or sale_pricerange_from = '0') and (sale_pricerange_to >= '36.3600' or sale_pricerange_to = '0') [254] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [255] => select products_type from zs_products where products_id = '132776' [256] => select type_handler from zs_product_types where type_id = '1' [257] => select parent_id from zs_categories where categories_id = '71' [258] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '132776' limit 1 [259] => select products_type from zs_products where products_id='132776' [260] => select allow_add_to_cart from zs_product_types where type_id = '1' [261] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '132776' [262] => select products_type from zs_products where products_id='132776' [263] => select allow_add_to_cart from zs_product_types where type_id = '1' [264] => select products_id, products_quantity_order_min from zs_products where products_id = '132776' [265] => select products_id, products_quantity_order_units from zs_products where products_id = '132776' [266] => select products_id, products_quantity_order_max from zs_products where products_id = '132776' [267] => select products_type from zs_products where products_id='132776' [268] => select type_handler from zs_product_types where type_id = '1' [269] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [270] => select products_type from zs_products where products_id = '131598' [271] => select type_handler from zs_product_types where type_id = '1' [272] => select parent_id from zs_categories where categories_id = '71' [273] => select products_description from zs_products_description where products_id = '131598' and language_id = '1' [274] => select products_type from zs_products where products_id = '131598' [275] => select type_handler from zs_product_types where type_id = '1' [276] => select parent_id from zs_categories where categories_id = '71' [277] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '131598' limit 1 [278] => select products_price, products_priced_by_attribute from zs_products where products_id = '131598' [279] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '131598' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [280] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '131598' [281] => select products_price, products_priced_by_attribute from zs_products where products_id = '131598' [282] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '131598' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [283] => select specials_new_products_price from zs_specials where products_id = '131598' and status='1' [284] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '131598' [285] => select products_price, products_priced_by_attribute from zs_products where products_id = '131598' [286] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '131598' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [287] => select specials_new_products_price from zs_specials where products_id = '131598' and status='1' [288] => select master_categories_id from zs_products where products_id = '131598' [289] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '70.2500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '70.2500' or sale_pricerange_to = '0') [290] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [291] => select products_type from zs_products where products_id = '131598' [292] => select type_handler from zs_product_types where type_id = '1' [293] => select parent_id from zs_categories where categories_id = '71' [294] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '131598' limit 1 [295] => select products_type from zs_products where products_id='131598' [296] => select allow_add_to_cart from zs_product_types where type_id = '1' [297] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '131598' [298] => select products_type from zs_products where products_id='131598' [299] => select allow_add_to_cart from zs_product_types where type_id = '1' [300] => select products_id, products_quantity_order_min from zs_products where products_id = '131598' [301] => select products_id, products_quantity_order_units from zs_products where products_id = '131598' [302] => select products_id, products_quantity_order_max from zs_products where products_id = '131598' [303] => select products_type from zs_products where products_id='131598' [304] => select type_handler from zs_product_types where type_id = '1' [305] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [306] => select products_type from zs_products where products_id = '120941' [307] => select type_handler from zs_product_types where type_id = '1' [308] => select parent_id from zs_categories where categories_id = '71' [309] => select products_description from zs_products_description where products_id = '120941' and language_id = '1' [310] => select products_type from zs_products where products_id = '120941' [311] => select type_handler from zs_product_types where type_id = '1' [312] => select parent_id from zs_categories where categories_id = '71' [313] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '120941' limit 1 [314] => select products_price, products_priced_by_attribute from zs_products where products_id = '120941' [315] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '120941' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [316] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '120941' [317] => select products_price, products_priced_by_attribute from zs_products where products_id = '120941' [318] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '120941' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [319] => select specials_new_products_price from zs_specials where products_id = '120941' and status='1' [320] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '120941' [321] => select products_price, products_priced_by_attribute from zs_products where products_id = '120941' [322] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '120941' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [323] => select specials_new_products_price from zs_specials where products_id = '120941' and status='1' [324] => select master_categories_id from zs_products where products_id = '120941' [325] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '42.1500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '42.1500' or sale_pricerange_to = '0') [326] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [327] => select products_type from zs_products where products_id = '120941' [328] => select type_handler from zs_product_types where type_id = '1' [329] => select parent_id from zs_categories where categories_id = '71' [330] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '120941' limit 1 [331] => select products_type from zs_products where products_id='120941' [332] => select allow_add_to_cart from zs_product_types where type_id = '1' [333] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '120941' [334] => select products_type from zs_products where products_id='120941' [335] => select allow_add_to_cart from zs_product_types where type_id = '1' [336] => select products_id, products_quantity_order_min from zs_products where products_id = '120941' [337] => select products_id, products_quantity_order_units from zs_products where products_id = '120941' [338] => select products_id, products_quantity_order_max from zs_products where products_id = '120941' [339] => select products_type from zs_products where products_id='120941' [340] => select type_handler from zs_product_types where type_id = '1' [341] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [342] => select products_type from zs_products where products_id = '163609' [343] => select type_handler from zs_product_types where type_id = '1' [344] => select parent_id from zs_categories where categories_id = '71' [345] => select products_description from zs_products_description where products_id = '163609' and language_id = '1' [346] => select products_type from zs_products where products_id = '163609' [347] => select type_handler from zs_product_types where type_id = '1' [348] => select parent_id from zs_categories where categories_id = '71' [349] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '163609' limit 1 [350] => select products_price, products_priced_by_attribute from zs_products where products_id = '163609' [351] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '163609' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [352] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '163609' [353] => select products_price, products_priced_by_attribute from zs_products where products_id = '163609' [354] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '163609' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [355] => select specials_new_products_price from zs_specials where products_id = '163609' and status='1' [356] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '163609' [357] => select products_price, products_priced_by_attribute from zs_products where products_id = '163609' [358] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '163609' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [359] => select specials_new_products_price from zs_specials where products_id = '163609' and status='1' [360] => select master_categories_id from zs_products where products_id = '163609' [361] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '57.0200' or sale_pricerange_from = '0') and (sale_pricerange_to >= '57.0200' or sale_pricerange_to = '0') [362] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [363] => select products_type from zs_products where products_id = '163609' [364] => select type_handler from zs_product_types where type_id = '1' [365] => select parent_id from zs_categories where categories_id = '71' [366] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '163609' limit 1 [367] => select products_type from zs_products where products_id='163609' [368] => select allow_add_to_cart from zs_product_types where type_id = '1' [369] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '163609' [370] => select products_type from zs_products where products_id='163609' [371] => select allow_add_to_cart from zs_product_types where type_id = '1' [372] => select products_id, products_quantity_order_min from zs_products where products_id = '163609' [373] => select products_id, products_quantity_order_units from zs_products where products_id = '163609' [374] => select products_id, products_quantity_order_max from zs_products where products_id = '163609' [375] => select products_type from zs_products where products_id='163609' [376] => select type_handler from zs_product_types where type_id = '1' [377] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [378] => select products_type from zs_products where products_id = '123274' [379] => select type_handler from zs_product_types where type_id = '1' [380] => select parent_id from zs_categories where categories_id = '71' [381] => select products_description from zs_products_description where products_id = '123274' and language_id = '1' [382] => select products_type from zs_products where products_id = '123274' [383] => select type_handler from zs_product_types where type_id = '1' [384] => select parent_id from zs_categories where categories_id = '71' [385] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '123274' limit 1 [386] => select products_price, products_priced_by_attribute from zs_products where products_id = '123274' [387] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '123274' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [388] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '123274' [389] => select products_price, products_priced_by_attribute from zs_products where products_id = '123274' [390] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '123274' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [391] => select specials_new_products_price from zs_specials where products_id = '123274' and status='1' [392] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '123274' [393] => select products_price, products_priced_by_attribute from zs_products where products_id = '123274' [394] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '123274' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [395] => select specials_new_products_price from zs_specials where products_id = '123274' and status='1' [396] => select master_categories_id from zs_products where products_id = '123274' [397] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '28.9300' or sale_pricerange_from = '0') and (sale_pricerange_to >= '28.9300' or sale_pricerange_to = '0') [398] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [399] => select products_type from zs_products where products_id = '123274' [400] => select type_handler from zs_product_types where type_id = '1' [401] => select parent_id from zs_categories where categories_id = '71' [402] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '123274' limit 1 [403] => select products_type from zs_products where products_id='123274' [404] => select allow_add_to_cart from zs_product_types where type_id = '1' [405] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '123274' [406] => select products_type from zs_products where products_id='123274' [407] => select allow_add_to_cart from zs_product_types where type_id = '1' [408] => select products_id, products_quantity_order_min from zs_products where products_id = '123274' [409] => select products_id, products_quantity_order_units from zs_products where products_id = '123274' [410] => select products_id, products_quantity_order_max from zs_products where products_id = '123274' [411] => select products_type from zs_products where products_id='123274' [412] => select type_handler from zs_product_types where type_id = '1' [413] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [414] => select products_type from zs_products where products_id = '125228' [415] => select type_handler from zs_product_types where type_id = '1' [416] => select parent_id from zs_categories where categories_id = '71' [417] => select products_description from zs_products_description where products_id = '125228' and language_id = '1' [418] => select products_type from zs_products where products_id = '125228' [419] => select type_handler from zs_product_types where type_id = '1' [420] => select parent_id from zs_categories where categories_id = '71' [421] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '125228' limit 1 [422] => select products_price, products_priced_by_attribute from zs_products where products_id = '125228' [423] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '125228' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [424] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '125228' [425] => select products_price, products_priced_by_attribute from zs_products where products_id = '125228' [426] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '125228' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [427] => select specials_new_products_price from zs_specials where products_id = '125228' and status='1' [428] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '125228' [429] => select products_price, products_priced_by_attribute from zs_products where products_id = '125228' [430] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '125228' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [431] => select specials_new_products_price from zs_specials where products_id = '125228' and status='1' [432] => select master_categories_id from zs_products where products_id = '125228' [433] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '40.5000' or sale_pricerange_from = '0') and (sale_pricerange_to >= '40.5000' or sale_pricerange_to = '0') [434] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [435] => select products_type from zs_products where products_id = '125228' [436] => select type_handler from zs_product_types where type_id = '1' [437] => select parent_id from zs_categories where categories_id = '71' [438] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '125228' limit 1 [439] => select products_type from zs_products where products_id='125228' [440] => select allow_add_to_cart from zs_product_types where type_id = '1' [441] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '125228' [442] => select products_type from zs_products where products_id='125228' [443] => select allow_add_to_cart from zs_product_types where type_id = '1' [444] => select products_id, products_quantity_order_min from zs_products where products_id = '125228' [445] => select products_id, products_quantity_order_units from zs_products where products_id = '125228' [446] => select products_id, products_quantity_order_max from zs_products where products_id = '125228' [447] => select products_type from zs_products where products_id='125228' [448] => select type_handler from zs_product_types where type_id = '1' [449] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [450] => select products_type from zs_products where products_id = '116341' [451] => select type_handler from zs_product_types where type_id = '1' [452] => select parent_id from zs_categories where categories_id = '71' [453] => select products_description from zs_products_description where products_id = '116341' and language_id = '1' [454] => select products_type from zs_products where products_id = '116341' [455] => select type_handler from zs_product_types where type_id = '1' [456] => select parent_id from zs_categories where categories_id = '71' [457] => select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zs_products where products_id = '116341' limit 1 [458] => select products_price, products_priced_by_attribute from zs_products where products_id = '116341' [459] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '116341' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [460] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '116341' [461] => select products_price, products_priced_by_attribute from zs_products where products_id = '116341' [462] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '116341' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [463] => select specials_new_products_price from zs_specials where products_id = '116341' and status='1' [464] => select products_price, products_model, products_priced_by_attribute from zs_products where products_id = '116341' [465] => select products_price, products_priced_by_attribute from zs_products where products_id = '116341' [466] => select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zs_products_attributes where products_id = '116341' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value [467] => select specials_new_products_price from zs_specials where products_id = '116341' and status='1' [468] => select master_categories_id from zs_products where products_id = '116341' [469] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from zs_salemaker_sales where sale_categories_all like '%,647,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '4.9600' or sale_pricerange_from = '0') and (sale_pricerange_to >= '4.9600' or sale_pricerange_to = '0') [470] => select sum(tax_rate) as tax_rate from (zs_tax_rates tr left join zs_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zs_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 = '56') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '227') and tr.tax_class_id = '2' group by tr.tax_priority [471] => select products_type from zs_products where products_id = '116341' [472] => select type_handler from zs_product_types where type_id = '1' [473] => select parent_id from zs_categories where categories_id = '71' [474] => select pa.products_attributes_id from zs_products_attributes pa where pa.products_id = '116341' limit 1 [475] => select products_type from zs_products where products_id='116341' [476] => select allow_add_to_cart from zs_product_types where type_id = '1' [477] => select product_is_call, products_quantity, products_sklad from zs_products where products_id = '116341' [478] => select products_type from zs_products where products_id='116341' [479] => select allow_add_to_cart from zs_product_types where type_id = '1' [480] => select products_id, products_quantity_order_min from zs_products where products_id = '116341' [481] => select products_id, products_quantity_order_units from zs_products where products_id = '116341' [482] => select products_id, products_quantity_order_max from zs_products where products_id = '116341' [483] => select products_type from zs_products where products_id='116341' [484] => select type_handler from zs_product_types where type_id = '1' [485] => select configuration_key, configuration_value from zs_product_type_layout where configuration_key='SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH' [486] => select configuration_key, configuration_value from zs_configuration where configuration_key RLIKE 'SHOW_PRODUCT_INFO_LISTING_BELOW' and configuration_value > 0 order by configuration_value [487] => select layout_box_name from zs_layout_boxes where layout_box_location=1 and layout_box_status=1 and layout_template ='mozen_temp' order by layout_box_sort_order [488] => select distinct p.products_id, pd.products_name, p.products_ordered from zs_products p, zs_products_description pd, zs_products_to_categories p2c, zs_categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_quantity > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '647' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name LIMIT 15 [489] => select p.products_image from zs_products p where products_id='123747' [490] => select products_name from zs_products_description where products_id = '123747' and language_id = '1' [491] => select products_type from zs_products where products_id = '123747' [492] => select type_handler from zs_product_types where type_id = '1' [493] => select p.products_image from zs_products p where products_id='122576' [494] => select products_name from zs_products_description where products_id = '122576' and language_id = '1' [495] => select products_type from zs_products where products_id = '122576' [496] => select type_handler from zs_product_types where type_id = '1' [497] => select p.products_image from zs_products p where products_id='123249' [498] => select products_name from zs_products_description where products_id = '123249' and language_id = '1' [499] => select products_type from zs_products where products_id = '123249' [500] => select type_handler from zs_product_types where type_id = '1' [501] => select p.products_image from zs_products p where products_id='122335' [502] => select products_name from zs_products_description where products_id = '122335' and language_id = '1' [503] => select products_type from zs_products where products_id = '122335' [504] => select type_handler from zs_product_types where type_id = '1' [505] => select p.products_image from zs_products p where products_id='120575' [506] => select products_name from zs_products_description where products_id = '120575' and language_id = '1' [507] => select products_type from zs_products where products_id = '120575' [508] => select type_handler from zs_product_types where type_id = '1' [509] => select p.products_image from zs_products p where products_id='121688' [510] => select products_name from zs_products_description where products_id = '121688' and language_id = '1' [511] => select products_type from zs_products where products_id = '121688' [512] => select type_handler from zs_product_types where type_id = '1' [513] => select p.products_image from zs_products p where products_id='121988' [514] => select products_name from zs_products_description where products_id = '121988' and language_id = '1' [515] => select products_type from zs_products where products_id = '121988' [516] => select type_handler from zs_product_types where type_id = '1' [517] => select p.products_image from zs_products p where products_id='121695' [518] => select products_name from zs_products_description where products_id = '121695' and language_id = '1' [519] => select products_type from zs_products where products_id = '121695' [520] => select type_handler from zs_product_types where type_id = '1' [521] => select p.products_image from zs_products p where products_id='68120' [522] => select products_name from zs_products_description where products_id = '68120' and language_id = '1' [523] => select products_type from zs_products where products_id = '68120' [524] => select type_handler from zs_product_types where type_id = '1' [525] => select p.products_image from zs_products p where products_id='161098' [526] => select products_name from zs_products_description where products_id = '161098' and language_id = '1' [527] => select products_type from zs_products where products_id = '161098' [528] => select type_handler from zs_product_types where type_id = '1' [529] => select p.products_image from zs_products p where products_id='123253' [530] => select products_name from zs_products_description where products_id = '123253' and language_id = '1' [531] => select products_type from zs_products where products_id = '123253' [532] => select type_handler from zs_product_types where type_id = '1' [533] => select p.products_image from zs_products p where products_id='82237' [534] => select products_name from zs_products_description where products_id = '82237' and language_id = '1' [535] => select products_type from zs_products where products_id = '82237' [536] => select type_handler from zs_product_types where type_id = '1' [537] => select p.products_image from zs_products p where products_id='55718' [538] => select products_name from zs_products_description where products_id = '55718' and language_id = '1' [539] => select products_type from zs_products where products_id = '55718' [540] => select type_handler from zs_product_types where type_id = '1' [541] => select p.products_image from zs_products p where products_id='82022' [542] => select products_name from zs_products_description where products_id = '82022' and language_id = '1' [543] => select products_type from zs_products where products_id = '82022' [544] => select type_handler from zs_product_types where type_id = '1' [545] => select p.products_image from zs_products p where products_id='121885' [546] => select products_name from zs_products_description where products_id = '121885' and language_id = '1' [547] => select products_type from zs_products where products_id = '121885' [548] => select type_handler from zs_product_types where type_id = '1' [549] => SELECT * FROM zs_mozen [550] => select pd.products_description,p.products_date_added,p.products_id, p.products_image, pd.products_name, p.master_categories_id from zs_products p left join zs_products_description pd on p.products_id = pd.products_id where p.products_date_added = ( select max(p.products_date_added) as last_u_date from zs_products p /*left join zs_products_description pd on p.products_id = pd.products_id */ where /*p.products_id = pd.products_id and*/ p.products_status = 1 /*and pd.language_id = '1 LIMIT 3'*/ ) and p.products_id = pd.products_id and p.products_status = 1 /*and pd.language_id = '1LIMIT 3' */ LIMIT 3 [551] => select p.products_id from zs_products p /*left join zs_products_description pd on p.products_id = pd.products_id */ where /*p.products_id = pd.products_id and */ p.products_status = 1 /*and pd.language_id = '1' */ ORDER BY p.products_id DESC LIMIT 1,1 [552] => select pd.products_description,p.products_date_added,p.products_id, p.products_image, pd.products_name, p.master_categories_id from zs_products p left join zs_products_description pd on p.products_id = pd.products_id where p.products_id = '221189' and p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' [553] => select p.products_id from zs_products p /*left join zs_products_description pd on p.products_id = pd.products_id */ where /*p.products_id = pd.products_id and*/ p.products_status = 1 /*and pd.language_id = '1'*/ ORDER BY p.products_id DESC LIMIT 2,1 [554] => select pd.products_description,p.products_date_added,p.products_id, p.products_image, pd.products_name, p.master_categories_id from zs_products p left join zs_products_description pd on p.products_id = pd.products_id where p.products_id ='221188' and p.products_id = pd.products_id and p.products_status = 1 /*and pd.language_id = '1' */ [555] => select * from zs_manufacturers ORDER BY RAND() LIMIT 5 [556] => select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url from zs_banners where status = 1 and ( banners_group = 'Wide-Banners') and banners_on_ssl= 1 order by rand() )