ارائه کنندگان
معیارهای جستجو
تبلیغات
021-55435143
@sedanmedsales
مرورگر شما بسیار قدیمی است!
جهت مشاهده این وب سایت به صورت صحیح، بروزرسانی مرورگرتان ضروری خواهد بود. بروزرسانی مرورگر
×
Parse Time: 0.119s
Duration Query
0.0000119209 SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0004639626 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.0001001358 SELECT * FROM languages ORDER BY sort_order ASC
0.0000028610 SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000979900 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.0002419949 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.0002548695 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.0002689362 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.0001530647 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.0001199245 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.0000748634 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.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.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.0000731945 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.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.0000720024 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.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.0000019073 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.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.0000741482 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.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.0000679493 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.0000669956 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.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.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.0000689030 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.0000689030 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.0000669956 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.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.0000698566 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.0000669956 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.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.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.0000681877 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('179') 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.0007839203 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('179') 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.0000119209 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000901222 SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = :id
0.0000038147 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.0019299984 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.0000879765 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000090599 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.0029590130 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.0000061989 SELECT parent_id FROM categories WHERE categories_id = :id
0.0001270771 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000038147 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000791550 SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_description, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE c.categories_id = :id AND cd.language_id = :language_id
0.0002160072 SELECT c.categories_id, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_description, cd.categories_name FROM categories AS c JOIN categories_description AS cd ON c.categories_id = cd.categories_id WHERE c.categories_id = :id AND cd.language_id = :language_id
0.0000071526 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001938343 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000121593 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0001649857 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000998974 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.0000941753 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000038147 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.0000040531 SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000970364 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.0001020432 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.0000951290 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.0000982285 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.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.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.0000028610 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.0001089573 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.0000030994 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.0000770092 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.0000030994 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.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.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.0001218319 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.0000770092 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.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.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.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.0000791550 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.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.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.0000760555 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.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.0000779629 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.0000820160 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.0025961399 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.0002169609 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.0005879402 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.0001900196 SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0000038147 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.0001509190 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.0001361370 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.0001299381 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.0002651215 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.0002200603 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.0000050068 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.0001900196 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.0001749992 SELECT * FROM banners WHERE banners_group = :group AND status = '1' ORDER BY sort_order ASC LIMIT 1
Total: 0.0185325146 Query count: 187