Parse Time: 0.129s
Duration Query
0.0000319481 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0026581287 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000059605 SELECT * FROM languages ORDER BY sort_order ASC
0.0003569126 SELECT * FROM languages ORDER BY sort_order ASC
0.0000059605 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0003731251 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000050068 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN ('12', '610', '611', '612', '613', '708', '722', '723', '724', '725', '726', '727', '731', '729', '614')
0.0017440319 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000081062 SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled != '' AND status = 0
0.0003380775 SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled != '' AND status = 0
0.0000040531 SELECT b.banners_id, b.expires_date, b.expires_impressions, SUM(bh.banners_shown) AS banners_shown FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.status = 1 GROUP BY b.banners_id
0.0044889450 SELECT b.banners_id, b.expires_date, b.expires_impressions, SUM(bh.banners_shown) AS banners_shown FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.status = 1 GROUP BY b.banners_id
0.0000061989 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0002501011 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0000040531 UPDATE chosen_products SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0002329350 UPDATE chosen_products SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0000059605 UPDATE products SET products_status = :available, products_last_modified = now() WHERE products_status = :upcoming AND (products_date_available IS NULL OR products_date_available = '0000-00-00 00:00:00' OR to_days(now()) >= to_days(products_date_available))
0.0000069141 UPDATE articles SET articles_status = 1, articles_last_modified = now(), articles_date_available = '' WHERE articles_status = 0 AND now() >= articles_date_available AND to_days(articles_date_available) > 0
0.0004718304 UPDATE articles SET articles_status = 1, articles_last_modified = now(), articles_date_available = '' WHERE articles_status = 0 AND now() >= articles_date_available AND to_days(articles_date_available) > 0
0.0000050068 SELECT configuration_id FROM configuration WHERE configuration_key = :ckey
0.0004708767 SELECT configuration_id FROM configuration WHERE configuration_key = :ckey
0.0000061989 UPDATE configuration SET configuration_value = :config_value, last_modified = now() WHERE configuration_id = :config_id
0.0002899170 UPDATE configuration SET configuration_value = :config_value, last_modified = now() WHERE configuration_id = :config_id
0.0000059605 SELECT ig.images_group_id, ig.save_path, ig.watermarking_status, ig.has_thumb, ig.thumb_width, ig.thumb_height, ig.max_width, ig.max_height, ig.default_image, ig.position, ig.multi_image, ig.date_added, ig.last_modified, ig.item_type, igi.images_group_title FROM images_group AS ig JOIN images_group_info AS igi ON igi.images_group_id=ig.images_group_id WHERE igi.languages_id = :languages_id
0.0004479885 SELECT ig.images_group_id, ig.save_path, ig.watermarking_status, ig.has_thumb, ig.thumb_width, ig.thumb_height, ig.max_width, ig.max_height, ig.default_image, ig.position, ig.multi_image, ig.date_added, ig.last_modified, ig.item_type, igi.images_group_title FROM images_group AS ig JOIN images_group_info AS igi ON igi.images_group_id=ig.images_group_id WHERE igi.languages_id = :languages_id
0.0000069141 SELECT products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered FROM products WHERE products_id = :products_id
0.0003008842 SELECT products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered FROM products WHERE products_id = :products_id
0.0000061989 SELECT products_name, products_url, products_viewed FROM products_description WHERE language_id = :language_id AND products_id = :products_id
0.0007400513 SELECT products_name, products_url, products_viewed FROM products_description WHERE language_id = :language_id AND products_id = :products_id
0.0000061989 SELECT specials_new_products_price, expires_date FROM specials WHERE products_id = :products_id AND status = 1
0.0003159046 SELECT specials_new_products_price, expires_date FROM specials WHERE products_id = :products_id AND status = 1
0.0000050068 SELECT products_related_id FROM import_cross_products WHERE products_id = :products_id
0.0002510548 SELECT products_related_id FROM import_cross_products WHERE products_id = :products_id
0.0000059605 SELECT products_id, products_description, products_meta_description, products_meta_keywords FROM products_description WHERE products_id = :products_id AND language_id = :language_id
0.0002830029 SELECT products_id, products_description, products_meta_description, products_meta_keywords FROM products_description WHERE products_id = :products_id AND language_id = :language_id
0.0000069141 SELECT m.*, mi.manufacturers_url, mi.url_clicked, mi.date_last_click FROM manufacturers AS m JOIN manufacturers_info AS mi ON m.manufacturers_id = mi.manufacturers_id WHERE m.manufacturers_id = :id AND mi.languages_id = :language_id
0.0003049374 SELECT m.*, mi.manufacturers_url, mi.url_clicked, mi.date_last_click FROM manufacturers AS m JOIN manufacturers_info AS mi ON m.manufacturers_id = mi.manufacturers_id WHERE m.manufacturers_id = :id AND mi.languages_id = :language_id
0.0000059605 SELECT ct.cloud_tags_id, ct.cloud_tags_counts, ct.cloud_tags_similars, ctd.cloud_tags_name FROM (cloud_tags_to_products AS c2p JOIN cloud_tags AS ct ON c2p.cloud_tags_id = ct.cloud_tags_id) JOIN cloud_tags_description AS ctd ON ct.cloud_tags_id = ctd.cloud_tags_id WHERE c2p.products_id = :products_id AND ctd.language_id = :language_id ORDER BY ct.cloud_tags_counts DESC
0.0116419792 SELECT ct.cloud_tags_id, ct.cloud_tags_counts, ct.cloud_tags_similars, ctd.cloud_tags_name FROM (cloud_tags_to_products AS c2p JOIN cloud_tags AS ct ON c2p.cloud_tags_id = ct.cloud_tags_id) JOIN cloud_tags_description AS ctd ON ct.cloud_tags_id = ctd.cloud_tags_id WHERE c2p.products_id = :products_id AND ctd.language_id = :language_id ORDER BY ct.cloud_tags_counts DESC
0.0000081062 SELECT catalog_images_id, image_filename FROM catalog_images WHERE images_group_id = :groupId AND item_id = :itemId ORDER BY order_id ASC
0.0023691654 SELECT catalog_images_id, image_filename FROM catalog_images WHERE images_group_id = :groupId AND item_id = :itemId ORDER BY order_id ASC
0.0000059605 SELECT catalog_images_id, image_filename FROM catalog_images WHERE images_group_id = :groupId AND item_id = :itemId ORDER BY order_id ASC
0.0016059875 SELECT catalog_images_id, image_filename FROM catalog_images WHERE images_group_id = :groupId AND item_id = :itemId ORDER BY order_id ASC
0.0000059605 SELECT v.videos_id, v.videos_poster, v.date_added, v.last_modified, vd.videos_title, vd.videos_description FROM videos AS v JOIN videos_description AS vd ON v.videos_id = vd.videos_id AND vd.language_id = :language_id JOIN videos_to_products AS v2p ON v.videos_id = v2p.videos_id WHERE v2p.products_id = :product_id AND v.enabled = 1 ORDER BY v2p.sort_order ASC
0.0004830360 SELECT v.videos_id, v.videos_poster, v.date_added, v.last_modified, vd.videos_title, vd.videos_description FROM videos AS v JOIN videos_description AS vd ON v.videos_id = vd.videos_id AND vd.language_id = :language_id JOIN videos_to_products AS v2p ON v.videos_id = v2p.videos_id WHERE v2p.products_id = :product_id AND v.enabled = 1 ORDER BY v2p.sort_order ASC
0.0002019405 SELECT pefg.products_extra_fields_groups_id, pefgd.products_extra_fields_groups_title FROM products_extra_fields_groups pefg, products_extra_fields_groups_description pefgd WHERE pefg.products_extra_fields_groups_status = 1 AND pefg.products_extra_fields_groups_id <> :default_group AND pefg.products_extra_fields_groups_id = pefgd.products_extra_fields_groups_id AND pefgd.language_id = :lng_id ORDER BY pefg.products_extra_fields_groups_order ASC
0.0004880428 SELECT pefg.products_extra_fields_groups_id, pefgd.products_extra_fields_groups_title FROM products_extra_fields_groups pefg, products_extra_fields_groups_description pefgd WHERE pefg.products_extra_fields_groups_status = 1 AND pefg.products_extra_fields_groups_id <> :default_group AND pefg.products_extra_fields_groups_id = pefgd.products_extra_fields_groups_id AND pefgd.language_id = :lng_id ORDER BY pefg.products_extra_fields_groups_order ASC
0.0000059605 SELECT p2e.*, e.products_extra_fields_name, e.products_extra_fields_order, e.products_extra_fields_status, e.products_extra_fields_groups_id, e.products_extra_fields_type_id FROM products_extra_fields AS e LEFT JOIN products_to_products_extra_fields AS p2e ON p2e.products_extra_fields_id = e.products_extra_fields_id WHERE p2e.products_id = :products_id AND (e.languages_id = '0' OR e.languages_id = :language_id) AND e.products_extra_fields_status = 1 ORDER BY e.products_extra_fields_order ASC
0.0007920265 SELECT p2e.*, e.products_extra_fields_name, e.products_extra_fields_order, e.products_extra_fields_status, e.products_extra_fields_groups_id, e.products_extra_fields_type_id FROM products_extra_fields AS e LEFT JOIN products_to_products_extra_fields AS p2e ON p2e.products_extra_fields_id = e.products_extra_fields_id WHERE p2e.products_id = :products_id AND (e.languages_id = '0' OR e.languages_id = :language_id) AND e.products_extra_fields_status = 1 ORDER BY e.products_extra_fields_order ASC
0.0000069141 SELECT products_extra_fields_id, products_extra_fields_lists_id, products_extra_fields_lists_name FROM products_extra_fields_lists ORDER BY products_extra_fields_lists_order ASC
0.0003490448 SELECT products_extra_fields_id, products_extra_fields_lists_id, products_extra_fields_lists_name FROM products_extra_fields_lists ORDER BY products_extra_fields_lists_order ASC
0.0000069141 SELECT a.products_attributes_id AS attributes_id, a.options_id, a.options_values_id AS values_id, a.options_values_price AS price, a.price_prefix, a.enabled, o.products_options_name AS options_name, o.products_options_type AS options_type, o.pages_id, v.products_options_values_name AS values_name, v.products_options_values_style AS values_style FROM (products_attributes AS a LEFT JOIN products_options AS o ON a.options_id = o.products_options_id) LEFT JOIN products_options_values AS v ON a.options_values_id = v.products_options_values_id WHERE a.products_id = :products_id AND o.language_id = :language_id AND v.language_id = :language_id ORDER BY o.sort_order ASC, a.sort_order ASC
0.0019841194 SELECT a.products_attributes_id AS attributes_id, a.options_id, a.options_values_id AS values_id, a.options_values_price AS price, a.price_prefix, a.enabled, o.products_options_name AS options_name, o.products_options_type AS options_type, o.pages_id, v.products_options_values_name AS values_name, v.products_options_values_style AS values_style FROM (products_attributes AS a LEFT JOIN products_options AS o ON a.options_id = o.products_options_id) LEFT JOIN products_options_values AS v ON a.options_values_id = v.products_options_values_id WHERE a.products_id = :products_id AND o.language_id = :language_id AND v.language_id = :language_id ORDER BY o.sort_order ASC, a.sort_order ASC
0.0000059605 SELECT count(reviews_id) AS count, SUM(reviews_rating) AS total FROM reviews WHERE products_id = :product_id AND approved = 1
0.0004720688 SELECT count(reviews_id) AS count, SUM(reviews_rating) AS total FROM reviews WHERE products_id = :product_id AND approved = 1
0.0000059605 UPDATE products_description SET products_viewed = products_viewed+1 WHERE products_id = :product_id AND language_id = :lang_id
0.0003039837 UPDATE products_description SET products_viewed = products_viewed+1 WHERE products_id = :product_id AND language_id = :lang_id
0.0000050068 SELECT categories_id FROM products_to_categories WHERE products_id = :products_id
0.0002441406 SELECT categories_id FROM products_to_categories WHERE products_id = :products_id
0.0000059605 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002579689 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000047684 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002238750 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002381802 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000061989 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0002419949 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000059605 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0002069473 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
Total: 0.0366523266 Query count: 69