معیارهای جستجو
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.225s
Duration Query
0.0000219345 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0010488033 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000050068 SELECT * FROM languages ORDER BY sort_order ASC
0.0005698204 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.0003418922 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.0005571842 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000109673 SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled != '' AND status = 0
0.0004601479 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.0047750473 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.0000050068 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0005080700 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0000038147 UPDATE chosen_products SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0001969337 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.0000050068 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.0003271103 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.0000040531 SELECT configuration_id FROM configuration WHERE configuration_key = :ckey
0.0003399849 SELECT configuration_id FROM configuration WHERE configuration_key = :ckey
0.0000040531 UPDATE configuration SET configuration_value = :config_value, last_modified = now() WHERE configuration_id = :config_id
0.0017650127 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.0003848076 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 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.0009222031 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.0000069141 SELECT COUNT(:countColumn) AS total from (products as p left join products_description as pd on p.products_id = pd.products_id left join specials as s on p.products_id = s.products_id and s.status = 1) where pd.language_id = :language_id and p.products_status > 0 and p.manufacturers_id in('15') order by pd.products_name asc
0.0010809898 SELECT COUNT(:countColumn) AS total from (products as p left join products_description as pd on p.products_id = pd.products_id left join specials as s on p.products_id = s.products_id and s.status = 1) where pd.language_id = :language_id and p.products_status > 0 and p.manufacturers_id in(:manufacturer_id) order by pd.products_name asc
0.0000050068 select p.*, pd.products_name, pd.products_viewed, s.specials_new_products_price as special_price from (products as p left join products_description as pd on p.products_id = pd.products_id left join specials as s on p.products_id = s.products_id and s.status = 1) where pd.language_id = :language_id and p.products_status > 0 and p.manufacturers_id in('15') order by pd.products_name asc LIMIT 0, 12
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002789497 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002729893 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000059605 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002210140 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002501011 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002219677 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000061989 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE cd.language_id = :lang_id ORDER BY c.sort_order
0.0034580231 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE cd.language_id = :lang_id ORDER BY c.sort_order
0.0000050068 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0004689693 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0000059605 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0004379749 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0000081062 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.0003190041 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.0000059605 SELECT * FROM products_extra_fields WHERE products_extra_fields_status = 1 AND (languages_id = 0 OR languages_id = :lng_id) ORDER BY products_extra_fields_order ASC
0.0019109249 SELECT * FROM products_extra_fields WHERE products_extra_fields_status = 1 AND (languages_id = 0 OR languages_id = :lng_id) ORDER BY products_extra_fields_order ASC
0.0000081062 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0004410744 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0000050068 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0004289150 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0000040531 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0004160404 SELECT p.pages_id, pd.pages_name FROM pages AS p, pages_description AS pd WHERE p.pages_status = '1' AND p.pages_id = pd.pages_id AND pd.language_id = :lng_id AND p.position_name = :position ORDER BY p.sort_order ASC, pd.pages_name ASC
0.0000071526 SELECT p.pages_id, pd.pages_name, pd.pages_description, p.pages_image, p.pages_date_added FROM pages AS p JOIN pages_description AS pd ON pd.pages_id = p.pages_id WHERE p.pages_status = '1' and pd.language_id = :lang_id AND p.position_name = :position ORDER BY p.sort_order LIMIT :limit
0.0003778934 SELECT p.pages_id, pd.pages_name, pd.pages_description, p.pages_image, p.pages_date_added FROM pages AS p JOIN pages_description AS pd ON pd.pages_id = p.pages_id WHERE p.pages_status = '1' and pd.language_id = :lang_id AND p.position_name = :position ORDER BY p.sort_order LIMIT :limit
Total: 0.0229690075 Query count: 58