ارائه کنندگان
معیارهای جستجو
تبلیغات
021-55435143
@sedanmedsales
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.116s
Duration Query
0.0000119209 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0005290508 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.0001349449 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.0002129078 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000040531 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.0002939701 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.0003049374 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.0000050068 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.0003008842 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.0001840591 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.0001430511 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.0001020432 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.0000882149 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.0000510216 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.0001058578 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.0001008511 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.0001010895 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.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000500679 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.0000488758 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.0000979900 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.0001001358 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.0001099110 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.0000829697 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.0000500679 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.0000488758 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000009537 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001001358 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.0000820160 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.0000779629 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.0000500679 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.0000870228 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.0000510216 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000009537 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001039505 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.0000548363 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.0000510216 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.0000500679 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.0000510216 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.0000488758 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.0000488758 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000059605 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.0000491142 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.0000989437 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.0000030994 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('1') 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.0009758472 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.0000030994 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('1') 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.0000760555 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000028610 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000619888 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000967979 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000030994 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.0000591278 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000572205 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 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.0000591278 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000019073 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000629425 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000028610 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000610352 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.0000028610 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000619888 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000040531 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.0018489361 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.0000028610 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000689030 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.0018961430 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.0000839233 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000669956 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000028610 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.0001280308 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.0001690388 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.0001189709 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.0001051426 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.0000028610 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.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.0000729561 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.0000870228 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.0000789165 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.0000758171 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.0000751019 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.0000751019 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.0000901222 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.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.0000751019 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.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.0000889301 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.0000798702 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.0000739098 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.0000030994 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.0001120567 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.0000760555 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.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.0000030994 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.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.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.0001080036 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.0000720024 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.0000720024 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.0000720024 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.0000848770 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.0000758171 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000028610 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.0025780201 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.0000040531 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.0003070831 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.0005841255 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.0000030994 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0002291203 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.0001971722 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.0000019073 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.0001249313 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.0001220703 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 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.0003199577 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 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.0001740456 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.0001690388 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.0000019073 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0001308918 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
Total: 0.0184385777 Query count: 209