ارائه کنندگان
معیارهای جستجو
تبلیغات
021-55435143
@sedanmedsales
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.109s
Duration Query
0.0000128746 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0004971027 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000038147 SELECT * FROM languages ORDER BY sort_order ASC
0.0001571178 SELECT * FROM languages ORDER BY sort_order ASC
0.0000040531 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0001628399 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.0002748966 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.0003349781 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.0000071526 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.0003089905 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.0002019405 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.0001461506 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.0001060963 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.0001041889 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.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.0000557899 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.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.0001049042 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.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.0000851154 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.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.0001299381 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.0001049042 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.0000851154 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.0000519753 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.0000498295 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.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.0001151562 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.0000519753 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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000498295 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.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.0000498295 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.0000519753 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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000479221 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.0000479221 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.0000498295 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.0001068115 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('157') 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.0012538433 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.0000028610 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('157') 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.0000061989 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0001041889 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000021458 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000741482 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.0019979477 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.0000779629 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.0018889904 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.0000820160 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000019073 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000579357 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.0001299381 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.0000028610 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001780987 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.0001311302 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.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.0000019073 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000851154 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.0000770092 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.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.0000600815 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.0000028610 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.0000021458 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001049042 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.0000860691 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.0001168251 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.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.0000030994 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.0001020432 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.0000028610 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.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.0001230240 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.0000529289 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.0000541210 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.0000019073 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.0000998974 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.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.0000600815 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.0000550747 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.0000498295 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.0000498295 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.0023889542 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.0002691746 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.0000019073 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.0006139278 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.0000028610 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0002551079 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
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.0001740456 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.0001609325 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.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.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.0002548695 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.0000019073 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.0001871586 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.0000021458 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.0001559258 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.0000030994 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
0.0001311302 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
Total: 0.0176835060 Query count: 189