ارائه کنندگان
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.479s
Duration Query
0.0000641346 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0017142296 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.0005590916 SELECT * FROM languages ORDER BY sort_order ASC
0.0000050068 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0022618771 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000059605 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.0008218288 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000100136 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.0038988590 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.0000109673 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_description, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE c.categories_id = :id AND cd.language_id = :language_id
0.0112550259 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_description, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE c.categories_id = :id AND cd.language_id = :language_id
0.0000059605 SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0003619194 SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0000059605 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) join products_to_categories as p2c on p.products_id = p2c.products_id where pd.language_id = :language_id and p.products_status > 0 and p2c.categories_id = :category_id order by p.products_status asc, if(s.status, s.specials_new_products_price, p.products_price) asc
0.0037090778 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) join products_to_categories as p2c on p.products_id = p2c.products_id where pd.language_id = :language_id and p.products_status > 0 and p2c.categories_id = :category_id order by p.products_status asc, if(s.status, s.specials_new_products_price, p.products_price) 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) join products_to_categories as p2c on p.products_id = p2c.products_id where pd.language_id = :language_id and p.products_status > 0 and p2c.categories_id = :category_id order by p.products_status asc, if(s.status, s.specials_new_products_price, p.products_price) asc LIMIT 0, 12
0.0000069141 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0003669262 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002541542 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000038147 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002200603 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000040531 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002241135 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000040531 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002489090 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002179146 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000040531 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002410412 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002260208 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0002160072 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000040531 SELECT DISTINCT m.manufacturers_id AS id, m.manufacturers_name AS name FROM products AS p JOIN products_to_categories AS p2c ON p.products_id = p2c.products_id JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status > 0 AND p2c.categories_id = :categories_id ORDER BY m.manufacturers_name ASC
0.0022778511 SELECT DISTINCT m.manufacturers_id AS id, m.manufacturers_name AS name FROM products AS p JOIN products_to_categories AS p2c ON p.products_id = p2c.products_id JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status > 0 AND p2c.categories_id = :categories_id ORDER BY m.manufacturers_name ASC
0.0000050068 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0002641678 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000050068 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0002498627 SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000350475 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.0165278912 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.0000071526 SELECT parent_id FROM categories WHERE categories_id = :id
0.0003609657 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000038147 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002200603 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 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.0052599907 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 parent_id FROM categories WHERE categories_id = :id
0.0002729893 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002169609 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002450943 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000040531 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002131462 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000040531 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002148151 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0003318787 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068 SELECT DISTINCT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image FROM products AS p JOIN products_to_categories AS p2c ON p.products_id = p2c.products_id JOIN manufacturers AS m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status > 0 AND p2c.categories_id IN ('298') ORDER BY m.manufacturers_name
0.0023670197 SELECT DISTINCT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image FROM products AS p JOIN products_to_categories AS p2c ON p.products_id = p2c.products_id JOIN manufacturers AS m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status > 0 AND p2c.categories_id IN (:cats) ORDER BY m.manufacturers_name
0.0000081062 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0009241104 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
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.0005230904 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.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.0115129948 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 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.0060679913 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 parent_id FROM categories WHERE categories_id = :id
0.0002501011 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT parent_id FROM categories WHERE categories_id = :id
0.0002181530 SELECT parent_id FROM categories WHERE categories_id = :id
Total: 0.0756103992 Query count: 75