| 0.0004 |
SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
AND `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
|
| 0.0001 |
select * from site_settings
|
| 0.0001 |
select tmp_name, site_id, site_name,parent,site_analytics_code,site_analytics_domain,site_domain,site_analytics_code_ga4 from cms_sites s JOIN cms_template t ON s.site_template=t.tmp_id where tmp_status=1 AND site_active=1 AND site_domain = 'https://www.medicareplusdev.molehost6.net/'
|
| 0.0001 |
select * from sso_sites where id='1'
|
| 0.0001 |
select * from lang_phrases where site_id = '1' AND status = '1'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'sso_enabled'
|
| 0.0001 |
select * from site_settings where set_key='site_maintenance'
|
| 0.0001 |
select * from installation where ini_status=1 and ini_controller!=''
|
| 0.0002 |
UPDATE `ci_sessions` SET `last_activity` = 1765030919, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";s:5:\"redir\";s:49:\"https://www.medicareplusdev.molehost6.net/careers\";}' WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030919, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";s:5:\"redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";}' WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
|
| 0.0004 |
select
pc.`id`,
pc.cat_name,
pc.parent_id,
pc.cat_url,
pc.cat_meta_title,
pc.cat_meta_desc,
pc.cat_meta_keyword,
pc.img_file_name,
pc.cat_div_class from
products_category pc where
pc.parent_id = '0' AND
pc.cat_active = 1 AND
pc.cat_status = 1 ORDER BY pc.cat_order ASC
|
| 0.0001 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '8'
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '8' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '15' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '16' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '17' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '18' ORDER BY c.cat_order ASC
|
| 0.0004 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (8,15,16,17,18)
|
| 0.0001 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '5'
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '5' ORDER BY c.cat_order ASC
|
| 0.0003 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '7' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '19' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '20' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '21' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '22' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '23' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '24' ORDER BY c.cat_order ASC
|
| 0.0003 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (5,7,19,20,21,22,23,24)
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '10'
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '10' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '25' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '26' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '27' ORDER BY c.cat_order ASC
|
| 0.0004 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (10,25,26,27)
|
| 0.0001 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '11'
|
| 0.0003 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '11' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '28' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '29' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '34' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '35' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '38' ORDER BY c.cat_order ASC
|
| 0.0002 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (11,28,29,34,35,38)
|
| 0.0001 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '13'
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '13' ORDER BY c.cat_order ASC
|
| 0.0004 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '30' ORDER BY c.cat_order ASC
|
| 0.0003 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '31' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '32' ORDER BY c.cat_order ASC
|
| 0.0003 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (13,30,31,32)
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND c.`id` = '39'
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '39' ORDER BY c.cat_order ASC
|
| 0.0002 |
select c.id,c.cat_name,c.parent_id,c.cat_order from products_category c where c.cat_status = 1 AND c.cat_active = 1 AND `parent_id` = '40' ORDER BY c.cat_order ASC
|
| 0.0003 |
select
p.prod_id from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
pic.cat_id IN (39,40)
|
| 0.0002 |
select
pc.`id`,
pc.cat_name,
pc.parent_id,
pc.cat_url,
pc.cat_meta_title,
pc.cat_meta_desc,
pc.cat_meta_keyword,
pc.img_file_name from
products_category pc where
pc.cat_collection = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 ORDER BY pc.cat_name ASC
|
| 0.0007 |
select
p.prod_id,
p.prod_title,
p.prod_url,
p.prod_code,
p.prod_details,
p.prod_finish,
p.prod_main_image,
pc.cat_name,
pc.`id` as cat_id from products_in_category pic LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_highlight_customer_choice = 1 GROUP BY p.prod_id
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'meta_no_follow'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'og_image'
|
| 0.0001 |
select core_file_path,min_file_path from sys_minify_files where `status` = 1
|
| 0.0001 |
select site_analytics_code_ga4 from cms_sites where site_id = '1'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030919, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";s:5:\"redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";}' WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1'
|
| 0.0001 |
select
ca.cmp_ad_id,
ca.cmp_ad_cmp_id,
ca.cmp_ad_fmat_id,
ca.cmp_ad_fmat_external,
ca.cmp_ad_bnr_size_id,
ca.cmp_ad_primary_file,
ca.cmp_ad_secondary_fmat_id,
ca.cmp_ad_secondary_file,
ca.cmp_ad_mobile_fmat_id,
ca.cmp_ad_bnr_mobile_size_id,
ca.cmp_ad_mobile_file,
ca.cmp_ad_dsp_id,
ca.cmp_ad_weighting,
ca.cmp_ad_repeat_display,
ca.cmp_ad_cross_ad_show_only_cmp,
ca.cmp_ad_cross_ad_show_other_cmp,
ca.cmp_hcp_disabled,
ca.cmp_ad_uprof_login_req,
ca.cmp_ad_uprof_login_not_req,
ca.cmp_ad_url,
ca.cmp_ad_fmat_external,
ca.cmp_ad_fmat_mobile_external,
f.fmat_id,
bs.bnr_id,
c.cmp_org_id from
ad_campaign_advert ca
LEFT JOIN ad_campaign c ON ca.cmp_ad_cmp_id = c.cmp_id
LEFT JOIN ad_banner_size bs ON ca.cmp_ad_bnr_size_id = bs.bnr_id
LEFT JOIN ad_format f ON ca.cmp_ad_fmat_id = f.fmat_id where ca.cmp_ad_status = 1 AND ca.cmp_ad_active = 1 AND c.cmp_status = 1 AND c.cmp_active = 1 AND c.site_id = '1' AND bs.bnr_status = 1 AND bs.bnr_active = 1 AND f.fmat_status = 1 AND f.fmat_active = 1 AND bs.bnr_id = '2' AND ca.cmp_ad_dsp_id = 2 AND (ca.cmp_ad_start_date <= '2025-12-06' AND ca.cmp_ad_end_date >= '2025-12-06') AND (c.cmp_start_date <= '2025-12-06' AND c.cmp_end_date >= '2025-12-06')
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'sso_enabled'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_main_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='389' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='390' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '207'
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_main_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='389' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='390' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '207'
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_footer_menu_2'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='6' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030919, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";s:5:\"redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";}' WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030919, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";s:5:\"redir\";s:50:\"https://www.medicareplusdev.molehost6.net/products\";}' WHERE `session_id` = '5293ec9bd9d94e952f31c4ac46c14164'
|
| 0.0001 |
select PC.id,PC.cat_name,PC.parent_id,PC.cat_order from products_category PC where PC.cat_status = 1 AND PC.cat_active = 1 ORDER BY PC.cat_order ASC
|
| 0.0003 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (15,16,17,18)
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'lifteez-adhesive-remover-aerosol-50ml'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '8' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '15' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '15' OR pl.like_prod_id = '15' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'lifteez-non-sting-adhesive-remover-wipes-30-pack'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '9' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '16' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '16' OR pl.like_prod_id = '16' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0003 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-barrier-cream-2g-sachets'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '10' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '17' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '17' OR pl.like_prod_id = '17' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-barrier-cream-tube'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '11' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '18' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '18' OR pl.like_prod_id = '18' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '20' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '20' OR pl.like_prod_id = '20' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-total-barrier-film-sterile-applicators'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '13' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '21' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '21' OR pl.like_prod_id = '21' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '22' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '22' OR pl.like_prod_id = '22' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-total-barrier-film-aerosol-50ml'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '14' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '23' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '23' OR pl.like_prod_id = '23' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-total-barrier-film-pump-spray-30-ml'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '15' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '24' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '24' OR pl.like_prod_id = '24' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-s-total-barrier-film-wipes-30-pack'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '16' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '25' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '25' OR pl.like_prod_id = '25' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-derma-pro-ointment-and-cleanser'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '36' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '82' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '82' OR pl.like_prod_id = '82' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '83' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '83' OR pl.like_prod_id = '83' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (7,19,20,21,22,23,24)
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'absopad-sterile-perforated-film-faced-absorbent-dressing'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '3' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '6' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '6' OR pl.like_prod_id = '6' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '7' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '7' OR pl.like_prod_id = '7' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '8' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '8' OR pl.like_prod_id = '8' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'adpore-sterile-absorbent-perforated-dressing-with-adhesive-border'
|
| 0.0005 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '19' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '28' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '28' OR pl.like_prod_id = '28' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '29' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '29' OR pl.like_prod_id = '29' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '30' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '30' OR pl.like_prod_id = '30' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '31' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '31' OR pl.like_prod_id = '31' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '32' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '32' OR pl.like_prod_id = '32' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '33' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '33' OR pl.like_prod_id = '33' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '34' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '34' OR pl.like_prod_id = '34' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'adpore-ultra-sterile-vapour-permeable-adhesive-film-dressing-with-absorbent-pad'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '20' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '35' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '35' OR pl.like_prod_id = '35' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '36' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '36' OR pl.like_prod_id = '36' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '37' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '37' OR pl.like_prod_id = '37' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '38' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '38' OR pl.like_prod_id = '38' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '39' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '39' OR pl.like_prod_id = '39' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '40' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '40' OR pl.like_prod_id = '40' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'cotton-stretch-bandage-bp'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '21' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '41' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '41' OR pl.like_prod_id = '41' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '42' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '42' OR pl.like_prod_id = '42' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '43' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '43' OR pl.like_prod_id = '43' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0003 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'crepe-bandage-bp'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '22' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '44' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '44' OR pl.like_prod_id = '44' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '45' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '45' OR pl.like_prod_id = '45' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '46' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '46' OR pl.like_prod_id = '46' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '47' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '47' OR pl.like_prod_id = '47' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'triangular-calico-bandage-bp'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '23' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '48' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '48' OR pl.like_prod_id = '48' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'nurse-it-sterile-dressing-packs'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '24' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '49' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '49' OR pl.like_prod_id = '49' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '50' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '50' OR pl.like_prod_id = '50' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'non-woven-fabric-swabs-dt-spec-28-non-sterile'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '25' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '51' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '51' OR pl.like_prod_id = '51' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'propack-hospital'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '26' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '52' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '52' OR pl.like_prod_id = '52' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '53' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '53' OR pl.like_prod_id = '53' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '54' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '54' OR pl.like_prod_id = '54' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '55' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '55' OR pl.like_prod_id = '55' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'propack-community'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '27' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '56' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '56' OR pl.like_prod_id = '56' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '57' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '57' OR pl.like_prod_id = '57' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '58' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '58' OR pl.like_prod_id = '58' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0003 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (25,26,27)
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-peak-flow-meter-range'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '28' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '59' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '59' OR pl.like_prod_id = '59' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '60' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '60' OR pl.like_prod_id = '60' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'sterile-irrigation-syringe'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '29' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '61' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '61' OR pl.like_prod_id = '61' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medi-oral-syringe-range'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '30' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '62' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '62' OR pl.like_prod_id = '62' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '63' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '63' OR pl.like_prod_id = '63' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (28,29,34,35,38)
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'dry-wipes'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '31' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '64' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '64' OR pl.like_prod_id = '64' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'disposal-black-bags'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '32' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '65' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '65' OR pl.like_prod_id = '65' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'cleansing-wet-wipes'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '37' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '84' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '84' OR pl.like_prod_id = '84' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'medicareplus-skin-prep-alcohol-wipes-100s'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '38' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '85' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '85' OR pl.like_prod_id = '85' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'chemiplasttm-sterile-washproof-spot-plasters-perforated'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '41' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '108' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '108' OR pl.like_prod_id = '108' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'chemiplasttm-sterile-washproof-spot-plasters-non-perforated'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '42' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '109' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '109' OR pl.like_prod_id = '109' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (30,31,32)
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'chemipore-permeable-non-woven-synthetic-adhesive-tape-bp'
|
| 0.0002 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '33' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '66' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '66' OR pl.like_prod_id = '66' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '67' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '67' OR pl.like_prod_id = '67' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '68' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '68' OR pl.like_prod_id = '68' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '69' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '69' OR pl.like_prod_id = '69' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'chemipore-pe-permeable-plastic-synthetic-adhesive-tape-bp'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '34' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '70' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '70' OR pl.like_prod_id = '70' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '71' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '71' OR pl.like_prod_id = '71' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '72' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '72' OR pl.like_prod_id = '72' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '73' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '73' OR pl.like_prod_id = '73' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'chemifix-permeable-apertured-non-woven-synthetic-adhesive-tape-bp'
|
| 0.0003 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '35' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0002 |
select * from products_finish_image where prod_extra_finish_id = '74' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '74' OR pl.like_prod_id = '74' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '75' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '75' OR pl.like_prod_id = '75' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '76' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '76' OR pl.like_prod_id = '76' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '77' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '77' OR pl.like_prod_id = '77' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '78' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '78' OR pl.like_prod_id = '78' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '80' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '80' OR pl.like_prod_id = '80' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '79' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '79' OR pl.like_prod_id = '79' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '81' AND img_status = 1
|
| 0.0002 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '81' OR pl.like_prod_id = '81' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0002 |
select
pic.prod_id,
p.prod_url from
products_in_category pic
LEFT JOIN products_category pc ON pic.cat_id = pc.`id`
LEFT JOIN products p ON pic.prod_id = p.prod_id where
pic.`status` = 1 AND
pic.`active` = 1 AND
pc.cat_active = 1 AND
pc.cat_status = 1 AND
p.prod_active = 1 AND
p.prod_status = 1 AND pic.cat_id IN (40)
|
| 0.0001 |
select p.*,pg.img_file_name as `guarantee_image` from products p
LEFT JOIN products_guarantee pg ON p.prod_guarantee_id = pg.`id` where
p.prod_active = 1 AND
p.prod_status = 1 AND
p.prod_url = 'sterile-irrigation-syringe'
|
| 0.0001 |
select
pf.finish_name,
ef.prod_finish_code,
ef.prod_finish_description,
ef.prod_finish_price,
ef.prod_finish_image,
ef.prod_extra_finish_id,
ef.prod_finish_vat_rate_id,
pf.finish_id,
ef.prod_finish_pack_size,
ef.prod_finish_pip_code,
ef.prod_finish_nhs_code,
ef.prod_finish_stock,
ef.prod_finish_stock_date,
ps.name as `stock_title` from products_extra_finishes ef
LEFT JOIN products_finishes pf ON ef.finish_id = pf.finish_id
LEFT JOIN products_stock ps ON ef.prod_finish_stock = ps.`id` where
pf.finish_active = 1 AND
pf.finish_status = 1 AND
ef.`status` = 1 AND
ef.`active` = 1 AND
ef.prod_id = '29' AND
ef.prod_finish_is_sample = 0 ORDER BY ef.`order` ASC
|
| 0.0001 |
select * from products_finish_image where prod_extra_finish_id = '61' AND img_status = 1
|
| 0.0001 |
select
pl.source_cat_id,
pl.source_extra_finish_id,
pl.like_prod_id,
pl.like_cat_id,
pl.reversed,
pef.prod_finish_code,
pf.finish_name,
pef.prod_extra_finish_id,
pf.finish_id from products_extra_finishes_likes pl
LEFT JOIN products_extra_finishes pef ON pl.like_finish_id = pef.prod_extra_finish_id
LEFT JOIN products_finishes pf ON pef.finish_id = pf.finish_id where (pl.source_extra_finish_id = '61' OR pl.like_prod_id = '61' AND pl.reversed = '1') AND pl.`status` = '1' AND pl.`active` = '1' ORDER BY pl.`order` ASC
|
| 0.0001 |
select prod_url from products where prod_id = '14'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '8' AND cat_active = 1 AND cat_status = 1
|
| 0.0002 |
select * from products_category where `id` = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '15'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '8' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select * from products_category where `id` = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '16'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '8' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select * from products_category where `id` = '16' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '19'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '19' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '5' AND cat_active = 1 AND cat_status = 1
|
| 0.0002 |
select * from products_category where `id` = '19' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '20'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '20' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '5' AND cat_active = 1 AND cat_status = 1
|
| 0.0002 |
select * from products_category where `id` = '20' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '24'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '22' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '5' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select * from products_category where `id` = '22' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select prod_url from products where prod_id = '28'
|
| 0.0001 |
select id,cat_url,parent_id,cat_name from products_category where id = '25' AND cat_active = 1 AND cat_status = 1
|
| 0.0002 |
select id,cat_url,parent_id,cat_name from products_category where id = '10' AND cat_active = 1 AND cat_status = 1
|
| 0.0002 |
select * from products_category where `id` = '25' AND cat_active = 1 AND cat_status = 1
|
| 0.0001 |
select wt.widget_type_handler from widgets_type wt INNER JOIN widgets w on w.widget_type_id=wt.widget_type_id where w.widget_id=374 AND w.widget_active=1 AND w.widget_status=1
|
| 0.0001 |
select * from widgets where widget_id=374
|
| 0.0001 |
select * from cms_menu where cmn_name='footer_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='406' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '1'
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '224'
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='407' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_pages where page_id = '54'
|
| 0.0001 |
select * from cms_pages where page_id = '205'
|
| 0.0001 |
select * from cms_pages where page_id = '178'
|
| 0.0001 |
select * from cms_pages where page_id = '204'
|
| 0.0002 |
INSERT INTO `logs_cms_pages` (`page_id`, `log_page_title`, `log_page_url`, `ses_db_id`) VALUES ('0', 'Our Product Portfolio', 'https://www.medicareplusdev.molehost6.net/products', 0)
|
Contact Us
My Account
Success!