تجهیزات چشم پزشکی

Duration	Function	Query
0.0003020763	prepare	SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0005559921	perform	SELECT configuration_id AS cfgId, configuration_key AS cfgKey, configuration_value AS cfgValue FROM configuration
0.0000050068	prepare	SELECT * FROM languages ORDER BY sort_order ASC
0.0001540184	perform	SELECT * FROM languages ORDER BY sort_order ASC
0.0000038147	prepare	SELECT source_name, alternative_key, alternative_value FROM alternative_texts WHERE languages_id = :languages_id
0.0000641346	perform	SELECT source_name, alternative_key, alternative_value FROM alternative_texts WHERE languages_id = :languages_id
0.0000050068	prepare	SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN ('12', '610', '611', '612', '613', '614', '708', '722', '723', '724', '725', '726', '727', '729', '731')
0.0000700951	perform	SELECT * FROM configuration_description WHERE (language_id = :languages_id OR language_id = 0) AND configuration_id IN (:configuration_id)
0.0000038147	prepare	SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000598431	perform	SELECT title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM currencies
0.0000040531	prepare	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.0001120567	perform	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	prepare	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.0009648800	perform	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	prepare	SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0003221035	perform	SELECT count(categories_id) FROM categories WHERE parent_id = :id
0.0000038147	prepare	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 p2c.categories_id = :category_id order by (p.products_status = 2) asc, p.products_status asc, pd.products_name asc
0.0018401146	perform	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 p2c.categories_id = :category_id order by (p.products_status = 2) asc, p.products_status asc, pd.products_name asc
0.0000030994	prepare	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 p2c.categories_id = :category_id order by (p.products_status = 2) asc, p.products_status asc, pd.products_name asc LIMIT 0, 12
0.0000028610	prepare	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0005970001	perform	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000030994	prepare	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0003190041	perform	SELECT categories_name FROM categories_description WHERE categories_id = :id AND language_id = :language_id
0.0000040531	prepare	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.0001761913	perform	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.0000038147	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002689362	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0002000332	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068	prepare	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.0001788139	perform	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	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000929832	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000040531	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000641346	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000040531	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000641346	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000629425	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000030994	prepare	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000700951	perform	SELECT parent_id FROM categories WHERE categories_id = :id
0.0000050068	prepare	SELECT IFNULL(s.specials_new_products_price, p.products_price) AS final_price, p.products_tax_class_id AS tax_class_id FROM (products AS p 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 products_status > 0 AND p2c.categories_id = :category_id ORDER BY final_price ASC LIMIT 1
0.0014281273	perform	SELECT IFNULL(s.specials_new_products_price, p.products_price) AS final_price, p.products_tax_class_id AS tax_class_id FROM (products AS p 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 products_status > 0 AND p2c.categories_id = :category_id ORDER BY final_price ASC LIMIT 1
0.0000040531	prepare	SELECT IFNULL(s.specials_new_products_price, p.products_price) AS final_price, p.products_tax_class_id AS tax_class_id FROM (products AS p 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 products_status > 0 AND p2c.categories_id = :category_id ORDER BY final_price DESC LIMIT 1
0.0014510155	perform	SELECT IFNULL(s.specials_new_products_price, p.products_price) AS final_price, p.products_tax_class_id AS tax_class_id FROM (products AS p 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 products_status > 0 AND p2c.categories_id = :category_id ORDER BY final_price DESC LIMIT 1
0.0000050068	prepare	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0002360344	perform	SELECT categories_id FROM categories WHERE parent_id = :id ORDER BY sort_order ASC
0.0000040531	prepare	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 ('9') ORDER BY m.manufacturers_name
0.0013999939	perform	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	prepare	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.0001020432	perform	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.0000040531	prepare	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 ('9', '0') AND (languages_id = 0 OR languages_id = :lng_id) ORDER BY e.products_extra_fields_order ASC
0.0012948513	perform	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	prepare	SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0001358986	perform	SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC LIMIT :limit
0.0000038147	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0004358292	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0004129410	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000038147	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003499985	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000030994	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003299713	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003581047	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0006880760	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000028610	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0004158020	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003349781	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	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.0000989437	perform	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	prepare	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.0000929832	perform	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	prepare	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.0000901222	perform	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	prepare	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.0000910759	perform	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	prepare	SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC
0.0000998974	perform	SELECT b.* FROM banners AS b WHERE b.status = '1' AND b.banners_group = :group ORDER BY sort_order ASC
0.0000050068	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003390312	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000038147	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003111362	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003859997	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0006179810	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0006368160	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000038147	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0002849102	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003359318	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003070831	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0006489754	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0002880096	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000050068	prepare	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0003437996	perform	SELECT COUNT(*) AS bc FROM banners_history WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0000040531	prepare	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
0.0002810955	perform	UPDATE banners_history SET banners_shown = banners_shown + 1 WHERE banners_id = :id AND date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
Total: 0.0213782787		Query count: 105

سرویس مشتریان

سرویس های معجزه

درباره معجزه

با معجزه کسب درآمد کنید

مرورگر شما بسیار قدیمی است!