اسلایدر صفحه نخست
اتوماسیون صنعتی
برق الکترونیک مخابرات
برق صنعتی
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.118s
Duration Query
0.0000278950 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0009610653 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.0002751350 SELECT * FROM languages ORDER BY sort_order ASC
0.0000069141 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0003130436 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.0004849434 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000059605 SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled != '' AND status = 0
0.0004160404 SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled != '' AND status = 0
0.0000071526 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.0039150715 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.0000069141 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0002479553 UPDATE specials SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0000050068 UPDATE chosen_products SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0002019405 UPDATE chosen_products SET status = 0, date_status_change = now() WHERE status = 1 AND expires_date < now() AND TO_DAYS(expires_date) > 0
0.0000061989 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.0000040531 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.0003402233 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.0000030994 SELECT configuration_id FROM configuration WHERE configuration_key = :ckey
0.0003149509 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.0002160072 UPDATE configuration SET configuration_value = :config_value, last_modified = now() WHERE configuration_id = :config_id
0.0000040531 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.0003330708 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.0000059605 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.0033249855 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.0000069141 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0005168915 SELECT manufacturers_id, manufacturers_name, manufacturers_image FROM manufacturers ORDER BY manufacturers_name ASC
0.0000059605 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC
0.0004310608 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC
0.0000040531 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003829002 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0004088879 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0000038147 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0004179478 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000059605 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0018999577 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003337860 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0006148815 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000047684 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003168583 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003790855 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
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 ORDER BY RAND() ASC LIMIT 1
0.0000069141 SELECT p.*, pd.products_name, s.specials_new_products_price AS special_price, s.status AS special_status, s.specials_date_added, s.expires_date 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 = :status AND s.specials_new_products_price > 0 ORDER BY ABS(UNIX_TIMESTAMP(s.expires_date) - UNIX_TIMESTAMP()) * RAND() ASC LIMIT 12
0.0000059605 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0003621578 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0000059605 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003829002 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000059605 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003039837 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0005640984 SELECT * FROM banners AS b LEFT JOIN banners_history AS bh ON b.banners_id = bh.banners_id WHERE b.banners_group = :group AND b.status = 1 AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068 SELECT cg.chosen_groups_id, cd.groups_title FROM chosen_groups AS cg JOIN chosen_groups_description AS cd ON cg.chosen_groups_id=cd.chosen_groups_id WHERE cd.language_id = :lng_id ORDER BY cg.sort_order ASC
0.0003330708 SELECT cg.chosen_groups_id, cd.groups_title FROM chosen_groups AS cg JOIN chosen_groups_description AS cd ON cg.chosen_groups_id=cd.chosen_groups_id WHERE cd.language_id = :lng_id ORDER BY cg.sort_order ASC
0.0000040531 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.products_id IN(SELECT ch.products_id FROM chosen_products AS ch WHERE ch.status = 1 AND ch.chosen_groups_id = :group_id) ORDER BY RAND() ASC LIMIT 20
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.products_id IN(SELECT ch.products_id FROM chosen_products AS ch WHERE ch.status = 1 AND ch.chosen_groups_id = :group_id) ORDER BY RAND() ASC LIMIT 20
0.0000059605 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0004360676 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
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 ORDER BY pd.products_viewed DESC LIMIT 12
0.0000059605 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0002849102 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0002369881 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0000059605 SELECT a.articles_id, a.articles_image, GREATEST(a.articles_date_added, COALESCE(a.articles_date_available, 0)) AS articles_date, a.articles_authors_id, ad.articles_name, ad.articles_summary, ad.articles_viewed FROM articles AS a JOIN articles_description AS ad ON a.articles_id = ad.articles_id JOIN articles_to_topics AS t ON a.articles_id = t.articles_id WHERE ad.language_id = :lng_id AND t.articles_topics_id NOT IN ('15', '1') AND a.articles_status = 1 ORDER BY articles_date DESC LIMIT 4
0.0005230904 SELECT a.articles_id, a.articles_image, GREATEST(a.articles_date_added, COALESCE(a.articles_date_available, 0)) AS articles_date, a.articles_authors_id, ad.articles_name, ad.articles_summary, ad.articles_viewed FROM articles AS a JOIN articles_description AS ad ON a.articles_id = ad.articles_id JOIN articles_to_topics AS t ON a.articles_id = t.articles_id WHERE ad.language_id = :lng_id AND t.articles_topics_id NOT IN (:id) AND a.articles_status = 1 ORDER BY articles_date DESC LIMIT 4
0.0000050068 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0002770424 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0000050068 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0002651215 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0000050068 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0002648830 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0000050068 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0002601147 SELECT articles_name FROM articles_description WHERE articles_id = :id AND language_id = :lng_id
0.0000059605 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0002460480 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0000038147 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0012769699 SELECT articles_topics_id FROM articles_topics WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531 SELECT a.articles_id, a.articles_image, GREATEST(a.articles_date_added, COALESCE(a.articles_date_available, 0)) AS articles_date, ad.articles_name, ad.articles_summary, ad.articles_viewed FROM articles AS a JOIN articles_description AS ad ON a.articles_id = ad.articles_id JOIN articles_to_topics AS t ON a.articles_id = t.articles_id WHERE ad.language_id = :lng_id AND t.articles_topics_id IN ('15', '1') AND a.articles_status = 1 ORDER BY articles_date DESC LIMIT 4
0.0004460812 SELECT a.articles_id, a.articles_image, GREATEST(a.articles_date_added, COALESCE(a.articles_date_available, 0)) AS articles_date, ad.articles_name, ad.articles_summary, ad.articles_viewed FROM articles AS a JOIN articles_description AS ad ON a.articles_id = ad.articles_id JOIN articles_to_topics AS t ON a.articles_id = t.articles_id WHERE ad.language_id = :lng_id AND t.articles_topics_id IN (:id) AND a.articles_status = 1 ORDER BY articles_date DESC LIMIT 4
0.0000059605 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.0004260540 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.0004179478 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.0000061989 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.0004808903 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.0000059605 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.0003960133 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.0255136490 Query count: 92