| 0.0006 |
SELECT * FROM (`ci_sessions`) WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9' 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` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:74:\"https://www.medicareplusdev.molehost6.net/blog/details/living-with-a-stoma\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 0.0002 |
UPDATE `ci_sessions` SET `last_activity` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 0.0003 |
select cs.cms_sec_url from cms_sections cs INNER JOIN cms_pages cp ON cp.cms_sec_id = cs.cms_sec_id where cp.page_url='home' AND cs.cms_sec_active=1 AND cs.cms_sec_status=1 AND cs.site_specific=1
|
| 0.0001 |
select * from cms_sites where site_id = '1'
|
| 0.0008 |
select * from cms_pages CP Join cms_sections CS on CP.cms_sec_id=CS.cms_sec_id Join cms_layout CL on CP.page_layout=CL.layout_id Join cms_page_contents CPC on CP.page_id=CPC.page_id where page_url='home' and CP.site_specific = '1' and CS.site_specific = '1' and page_active=1 and page_status=1 and CPC.cont_status=1
|
| 0.0002 |
UPDATE `ci_sessions` SET `last_activity` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 0.0005 |
select * from cms_page_topic where page_id = '1' AND cms_page_topic_status = 1 AND cms_page_topic_active = 1
|
| 0.0001 |
select activity_action_id from activity_action where activity_action_id = '105'
|
| 0.0004 |
DESCRIBE `activity_user_action`
|
| 0.0005 |
INSERT INTO `activity_user_action` (`activity_action_id`, `site_id`, `activity_user_action_detail_id`, `activity_user_action_detail`, `activity_user_action_ref_url`, `viewed_url`, `usr_ip_address`, `usr_session_id`, `usr_agent`, `usr_browser`) VALUES (105, '1', '1', 'Wound Healing Innovation', '', 'https://www.medicareplusdev.molehost6.net/home', '216.73.216.135', '7620b9e9f0d294d329765a0588cbb1c9', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Mozilla - 5.0')
|
| 0.0003 |
select * from cms_banner_groups where bgrp_id='91' and bgrp_status=1
|
| 0.0005 |
select CB.* from cms_banner CB Join cms_banner_in_group BIG on CB.banner_id=BIG.banner_id where BIG.bgrp_id=91 and banner_status=1 and banner_active=1 and bgp_status=1 order by RAND()
|
| 0.0019 |
select * from cms_blocks CB Join cms_block_sizes BS on CB.size_id=BS.size_id left join cms_block_options BO on BO.cbo_id=block_type where cont_id='1056' and block_col_parent_id=0 and block_status=1 order by block_order
|
| 0.0016 |
select PW.*, W.*, WT.* from page_widgets PW Join widgets W on PW.widget_id = W.widget_id join widgets_type WT on W.widget_type_id =WT.widget_type_id INNER JOIN widget_display_sites wds ON wds.wdg_id = W.widget_id where cont_id='1056' and page_widget_status=1 and widget_active=1 AND wds.wdg_display_site_id=1 AND wds.status='1' order by page_widget_order
|
| 0.0017 |
select DISTINCT W.*, PW.*, WT.* from page_widgets PW Join widgets W on PW.widget_id = W.widget_id join widgets_type WT on W.widget_type_id =WT.widget_type_id LEFT JOIN widget_display_sites wds ON wds.wdg_id = W.widget_id where cont_id='1056' and page_widget_status=1 and widget_active=1 order by page_widget_order
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 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` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 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.0000 |
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.0000 |
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` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765030876, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:5:\"redir\";s:46:\"https://www.medicareplusdev.molehost6.net/home\";s:22:\"resource_reading_redir\";s:94:\"https://www.medicareplusdev.molehost6.net/resources/details/skin-moisture-alert-reporting-tool\";}' WHERE `session_id` = '7620b9e9f0d294d329765a0588cbb1c9'
|
| 0.0001 |
select * from cms_sites where site_id = '1'
|
| 0.0006 |
select * from cms_pages CP Join cms_sections CS on CP.cms_sec_id=CS.cms_sec_id Join cms_layout CL on CP.page_layout=CL.layout_id Join cms_page_contents CPC on CP.page_id=CPC.page_id where page_url='home' and CS.site_specific = '1' and page_active=1 and page_status=1 and CPC.cont_status=1
|
| 0.0001 |
select * from widgets_groups where wgrp_id='58' and wgrp_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=366 AND w.widget_active=1 AND w.widget_status=1
|
| 0.0001 |
select * from widgets where widget_id=366
|
| 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=365 AND w.widget_active=1 AND w.widget_status=1
|
| 0.0001 |
select * from widgets where widget_id=365
|
| 0.0004 |
select pc.`id`, pc.cat_name, pc.parent_id, pc.cat_url, pc.img_file_name, pc.cat_description from products_category pc where pc.cat_active = 1 AND pc.cat_status = 1 AND pc.cat_homepage_widget_highlight IN (2,3) AND pc.img_file_name <> '' ORDER BY RAND() LIMIT 2
|
| 0.0003 |
select pc.`id`, pc.cat_name, pc.parent_id, pc.cat_url, pc.img_file_name, pc.cat_description from products_category pc where pc.cat_active = 1 AND pc.cat_status = 1 AND pc.cat_homepage_widget_highlight IN (1,3) AND pc.img_file_name <> '' ORDER BY RAND() LIMIT 1
|
| 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.0002 |
select id,cat_url,parent_id,cat_name from products_category where id = '17' 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 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 (17)
|
| 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-pro-ointment-and-cleanser'
|
| 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 = '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.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 = '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.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 = '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.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 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 (16)
|
| 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.0000 |
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.0000 |
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.0000 |
select * from products_finish_image where prod_extra_finish_id = '23' AND img_status = 1
|
| 0.0000 |
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.0000 |
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.0000 |
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 id,cat_url,parent_id,cat_name from products_category where id = '18' AND cat_active = 1 AND cat_status = 1
|
| 0.0000 |
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 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 (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.0000 |
select * from products_finish_image where prod_extra_finish_id = '15' AND img_status = 1
|
| 0.0000 |
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.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=369 AND w.widget_active=1 AND w.widget_status=1
|
| 0.0001 |
select * from widgets where widget_id=369
|
| 0.0008 |
select
n.nws_id AS `item_id`,
n.nws_title AS `item_title`,
n.nws_heading AS `item_heading`,
n.nws_url AS `item_link`,
n.nws_image AS `item_image`,
n.nws_date AS `item_date`,
'news' AS `item_type` from news n where
n.nws_status = 1 AND
n.nws_active = 1 AND
n.nws_archived = 0 AND
n.nws_image <> ''
UNION
SELECT
b.blog_id AS `item_id`,
b.blog_title AS `item_title`,
b.blog_heading AS `item_heading`,
b.blog_url AS `item_link`,
b.blog_image AS `item_image`,
b.blog_date AS `item_date`,
'blog' AS `item_type`
FROM blog b
WHERE
b.blog_status = 1 AND
b.blog_active = 1 AND
b.blog_archived = 0 AND
b.blog_image <> '' ORDER BY RAND() LIMIT 10
|
| 0.0003 |
select
t.testimonial_name,
t.testimonial_text from testimonial t where
t.testimonial_status = 1 AND
t.testimonial_active = 1 ORDER BY RAND()
|
| 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.0001 |
INSERT INTO `logs_cms_pages` (`page_id`, `log_page_title`, `log_page_url`, `ses_db_id`) VALUES ('1', 'Wound Healing Innovation', 'https://www.medicareplusdev.molehost6.net/home', 0)
|