ارائه کنندگان
معیارهای جستجو
تبلیغات
021-55435143
@sedanmedsales
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.115s
Duration Query
0.0000131130 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0005910397 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000040531 SELECT * FROM languages ORDER BY sort_order ASC
0.0001819134 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.0001809597 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.0003018379 SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000050068 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.0002698898 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.0000040531 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.0002329350 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.0000040531 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001590252 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.0001358986 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.0000817776 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.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.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.0000810623 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.0000019073 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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001101494 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.0000810623 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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000770092 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.0001111031 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.0000009537 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.0000028610 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.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.0000739098 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.0001161098 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000171661 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.0000021458 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.0000159740 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.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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000748634 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.0000021458 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.0000019073 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.0000019073 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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000801086 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.0000748634 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.0000040531 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('88') 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.0012021065 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('88') 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.0000059605 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000901222 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_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.0026237965 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.0000040531 SELECT parent_id FROM categories WHERE categories_id = :id
0.0001161098 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.0026500225 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.0000040531 SELECT parent_id FROM categories WHERE categories_id = :id
0.0001718998 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000028610 SELECT parent_id FROM categories WHERE categories_id = :id
0.0001120567 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.0001490116 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.0001630783 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.0001449585 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.0001039505 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.0001089573 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.0001089573 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.0001080036 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.0001299381 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.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.0000560284 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.0000538826 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.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.0001118183 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.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.0001778603 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.0001649857 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.0001070499 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.0001080036 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.0001089573 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.0001080036 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.0001220703 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.0000569820 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.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.0000541210 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.0000560284 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.0000030994 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.0000030994 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000531673 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.0001130104 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.0001089573 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.0000910759 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.0000588894 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.0000529289 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.0000541210 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000019073 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.0025358200 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.0001997948 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.0000028610 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.0006501675 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.0002729893 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.0001800060 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.0001759529 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.0001721382 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 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.0002219677 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.0002009869 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.0002169609 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.0000021458 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0001599789 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
Total: 0.0202531815 Query count: 187