گنج کالا - رنگ ساختمانی

Duration	Query
0.0000391006	SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0042941570	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.0002770424	SELECT * FROM languages ORDER BY sort_order ASC
0.0000100136	SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0004940033	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.0052969456	SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000088215	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.0005879402	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.0000100136	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.0200569630	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.0000071526	SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0004510880	SELECT count(categories_id) FROM categories WHERE parent_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 AND c.parent_id = :root ORDER BY c.sort_order
0.0006949902	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 AND c.parent_id = :root ORDER BY c.sort_order
0.0000061989	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0002889633	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.0002360344	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000398159	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.0175449848	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.0000100136	SELECT parent_id FROM categories WHERE categories_id = :id
0.0115389824	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000059605	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002479553	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000379086	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.0054190159	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.0002439022	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002188683	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002179146	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002160072	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000040531	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002150536	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, 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.0108630657	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.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0004339218	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0223991871	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000081062	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0004470348	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002450943	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002789497	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002379417	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002379417	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0217931271	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000069141	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0387110710	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000121593	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0003328323	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002839565	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002410412	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002381802	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002388954	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 ('14', '246', '247', '248', '249', '15', '22', '104', '332', '331', '163', '204', '291', '273') ORDER BY m.manufacturers_name
0.0071868896	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.0000050068	SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0100200176	SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0000090599	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0005009174	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0003230572	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0003161430	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002419949	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002410412	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002899170	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002470016	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002408028	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0003030300	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002400875	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002379417	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002698898	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002369881	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000050068	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002579689	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000309944	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 LEFT JOIN products_to_categories AS p2c ON ch.products_id = p2c.products_id WHERE ch.status = 1 AND p2c.categories_id IN ('14', '246', '247', '248', '249', '15', '22', '104', '332', '331', '163', '204', '291', '273')) ORDER BY RAND() ASC LIMIT 15
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.0432450771	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.0000069141	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.0113677979	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.0058338642	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.0023140907	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000081062	SELECT parent_id FROM categories WHERE categories_id = :id
0.0095891953	SELECT parent_id FROM categories WHERE categories_id = :id
Total: 0.2594773769	Query count: 111

اطلاعات تماس

راهنمای مشتریان

دسته بندی ها

رهگیری سفارش

مرورگر شما بسیار قدیمی است!