ارائه کنندگان
معیارهای جستجو
تبلیغات
021-55435143
@sedanmedsales
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.106s
Duration Query
0.0000138283 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0005300045 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000030994 SELECT * FROM languages ORDER BY sort_order ASC
0.0001060963 SELECT * FROM languages ORDER BY sort_order ASC
0.0000030994 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000998974 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000030994 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', '1718')
0.0002050400 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_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.0001828671 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.0000038147 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.0002250671 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.0000028610 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001139641 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001211166 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000689030 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000679493 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000660419 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000700951 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000681877 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000641346 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000641346 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000638962 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000638962 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000898838 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000681877 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000700951 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000658035 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000660419 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000629425 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000638962 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000679493 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001029968 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000679493 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000641346 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000629425 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000631809 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000700951 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000669956 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000698566 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000629425 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000638962 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000629425 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000839233 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000638962 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000028610 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 p.manufacturers_id in('156') and p2c.categories_id in('1', '157', '158', '159', '160', '161', '163', '165', '166', '167', '168', '384', '408', '216', '209', '174', '208', '217', '232', '231', '5', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '6', '7') order by pd.products_name asc
0.0009729862 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 p.manufacturers_id in(:manufacturer_id) and p2c.categories_id in(:category_id) order by pd.products_name asc
0.0000021458 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 p.manufacturers_id in('156') and p2c.categories_id in('1', '157', '158', '159', '160', '161', '163', '165', '166', '167', '168', '384', '408', '216', '209', '174', '208', '217', '232', '231', '5', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '6', '7') order by pd.products_name asc LIMIT 0, 12
0.0000050068 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000770092 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000650883 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000021458 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000598431 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000588894 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000581741 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000569820 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000619888 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000021458 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000591278 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000021458 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000579357 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000591278 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000591278 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000560284 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 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.0017449856 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.0000030994 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000710487 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994 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.0017669201 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.0000030994 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000729561 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000021458 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000631809 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994 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.0000998974 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.0000040531 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001549721 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001180172 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000879765 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000741482 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000729561 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000720024 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000739098 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000720024 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000150204 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000860691 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000989437 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000729561 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001029968 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000720024 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000739098 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000739098 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000028610 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000739098 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001070499 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000729561 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001029968 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000708103 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000720024 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000028610 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000708103 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000729561 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000720024 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000710487 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000708103 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000030994 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 ('157', '158', '159', '160', '161', '163', '165', '166', '167', '168', '384', '408', '216', '209', '174', '208', '217', '232', '231', '5', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '6', '7', '1') ORDER BY m.manufacturers_name
0.0024909973 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.0000030994 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.0002701283 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.0000030994 SELECT e.* FROM products_extra_fields AS e LEFT JOIN products_extra_fields_to_categories e2c ON e.products_extra_fields_id = e2c.products_extra_fields_id WHERE e.products_extra_fields_status = 1 AND e2c.categories_id IN ('1', '157', '158', '159', '160', '161', '163', '165', '166', '167', '168', '384', '408', '216', '209', '174', '208', '217', '232', '231', '5', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '6', '7', '0') AND (languages_id = 0 OR languages_id = :lng_id) ORDER BY e.products_extra_fields_order ASC
0.0006570816 SELECT e.* FROM products_extra_fields AS e LEFT JOIN products_extra_fields_to_categories e2c ON e.products_extra_fields_id = e2c.products_extra_fields_id WHERE e.products_extra_fields_status = 1 AND e2c.categories_id IN (:cat_id) AND (languages_id = 0 OR languages_id = :lng_id) ORDER BY e.products_extra_fields_order ASC
0.0000040531 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0002081394 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0000030994 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.0001709461 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.0000028610 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.0001230240 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.0000030994 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.0001208782 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 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.0002779961 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.0001718998 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.0000030994 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.0001289845 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.0000028610 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0001251698 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
Total: 0.0170729160 Query count: 209