Start |
End |
Duration |
Query |
Path |
Function |
0.0005 | 0.0014 | 0.00093 |
select * from WebAttributes as att
where att.aname=':availableto'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 85 | __construct |
0.0017 | 0.0019 | 0.00017 | select * from COCurrencies; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 265 | __construct |
0.0019 | 0.0021 | 0.00019 | SELECT * from WebCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2073 | getWebCustomerDetails |
0.0022 | 0.0023 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.0023 | 0.0025 | 0.00021 | select * from WebContent where pagename='Home' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/content.php line 92 | __construct |
0.0026 | 0.0029 | 0.00034 | SELECT * FROM WebContent WHERE articleno = 1 AND visible = 'Y' ORDER BY pageno | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/content.php line 160 | __construct |
0.0034 | 0.0036 | 0.00021 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.0037 | 0.0038 | 0.00013 |
select * from WebCategoryAliases
where alias = 'Products' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 218 | setCategoryPage |
0.0039 | 0.0041 | 0.0002 | select c.*,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005' and visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 258 | setCategoryPage |
0.0041 | 0.0043 | 0.00022 | select a.aname,ca.value_ from WebCategoryAttributes as ca
left join WebAttributes as a on ca.attribute = a.code
where ca.category = '0005'
and ca.value_ <> '' order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 319 | setCategoryPage |
0.0043 | 0.0045 | 0.00015 |
select * from WebAttributes as att
where att.aname=':keywords'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 423 | setCategoryPage |
0.0045 | 0.0046 | 0.00012 |
select * from WebCategoryAttributes as ca
where ca.category='0005' and ca.attribute=7
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 442 | setCategoryPage |
0.0046 | 0.0048 | 0.00015 |
select * from WebAttributes as att
where att.aname=':metadesc'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 457 | setCategoryPage |
0.0048 | 0.0049 | 0.00011 |
select * from WebCategoryAttributes as ca
where ca.category='0005' and ca.attribute=8
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 476 | setCategoryPage |
0.0049 | 0.0051 | 0.00015 |
select * from WebAttributes as att
where att.aname=':pagetitle'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 491 | setCategoryPage |
0.0051 | 0.0053 | 0.00016 |
select * from WebCategoryAttributes as ca
where ca.category='0005' and ca.attribute=6
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 510 | setCategoryPage |
0.0053 | 0.0056 | 0.00028 |
select * from WebProducts as p
where p.stockcode = 'hair-care' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 555 | setProductPage |
0.0056 | 0.0057 | 0.00016 |
select * from WebCategoryAliases
where alias = 'hair-care' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 218 | setCategoryPage |
0.0058 | 0.0060 | 0.00024 | select c.*,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001' and visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 258 | setCategoryPage |
0.0060 | 0.0062 | 0.00023 | select a.aname,ca.value_ from WebCategoryAttributes as ca
left join WebAttributes as a on ca.attribute = a.code
where ca.category = '00050035002400070001'
and ca.value_ <> '' order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 319 | setCategoryPage |
0.0063 | 0.0064 | 0.00012 |
select * from WebCategoryAttributes as ca
where ca.category='00050035002400070001' and ca.attribute=7
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 442 | setCategoryPage |
0.0064 | 0.0065 | 0.00011 |
select * from WebCategoryAttributes as ca
where ca.category='00050035002400070001' and ca.attribute=8
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 476 | setCategoryPage |
0.0065 | 0.0066 | 0.00011 |
select * from WebCategoryAttributes as ca
where ca.category='00050035002400070001' and ca.attribute=6
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 510 | setCategoryPage |
0.0067 | 0.0068 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0070 | 0.0071 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0072 | 0.0073 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0073 | 0.0075 | 0.00016 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='0005' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0075 | 0.0077 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0077 | 0.0078 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0078 | 0.0080 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0080 | 0.0082 | 0.0002 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='00050035' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0082 | 0.0083 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0084 | 0.0085 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0085 | 0.0086 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0086 | 0.0088 | 0.00015 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='000500350024' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0088 | 0.0089 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0089 | 0.0091 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0091 | 0.0092 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0092 | 0.0094 | 0.00015 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='0005003500240007' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0094 | 0.0096 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003500240007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0096 | 0.0097 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003500240007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0097 | 0.0099 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003500240007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0099 | 0.0101 | 0.00015 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='00050035002400070001' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0101 | 0.0102 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0102 | 0.0104 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0104 | 0.0119 | 0.0015 |
SELECT c.category,c.shorttitle,c.ctitle,ca.alias,c.grpproducts FROM WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where visible='Y' AND LENGTH(c.category) <= 12
ORDER BY LENGTH(c.category), lstorder
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2332 | getCategoryMegaMenu |
0.0122 | 0.0137 | 0.0016 |
SELECT c.category,c.shorttitle,c.ctitle,ca.alias,c.grpproducts FROM WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where visible='Y' and c.category like '0005%' AND LENGTH(c.category) <= 12 and c.category like '0005%'
ORDER BY LENGTH(c.category), lstorder
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2332 | getCategoryMegaMenu |
0.0143 | 0.0144 | 0.00019 | select * from WebCategoryAttributes
where category = '000500830001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0145 | 0.0146 | 0.00013 | select * from WebCategoryAttributes
where category = '00050083'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0146 | 0.0147 | 0.00012 | select * from WebCategoryAttributes
where category = '0005'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0147 | 0.0149 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500830001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0149 | 0.0150 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500830001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0150 | 0.0152 | 0.00012 | select * from WebCategoryAttributes
where category = '000500830002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0152 | 0.0153 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500830002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0153 | 0.0154 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500830002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0155 | 0.0157 | 0.00028 | select * from WebCategoryAttributes
where category = '000500830008'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0158 | 0.0160 | 0.0002 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500830008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0160 | 0.0161 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500830008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0161 | 0.0163 | 0.00012 | select * from WebCategoryAttributes
where category = '000500830009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0163 | 0.0164 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500830009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0164 | 0.0165 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500830009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0166 | 0.0167 | 0.00012 | select * from WebCategoryAttributes
where category = '000500200001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0167 | 0.0168 | 0.00011 | select * from WebCategoryAttributes
where category = '00050020'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0168 | 0.0170 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500200001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0170 | 0.0171 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500200001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0171 | 0.0172 | 0.00012 | select * from WebCategoryAttributes
where category = '000500200002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0173 | 0.0174 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500200002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0174 | 0.0175 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500200002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0175 | 0.0176 | 0.00011 | select * from WebCategoryAttributes
where category = '00050020000e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0177 | 0.0178 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050020000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0178 | 0.0179 | 9.9999999999999E-5 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050020000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0179 | 0.0180 | 0.00011 | select * from WebCategoryAttributes
where category = '000500200010'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0180 | 0.0182 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500200010'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0182 | 0.0183 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500200010'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0183 | 0.0184 | 0.00011 | select * from WebCategoryAttributes
where category = '000500200009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0185 | 0.0186 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500200009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0186 | 0.0187 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500200009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0187 | 0.0188 | 9.9999999999999E-5 | select * from WebCategoryAttributes
where category = '000500200011'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0188 | 0.0190 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500200011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0190 | 0.0191 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500200011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0191 | 0.0193 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003a002e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0193 | 0.0194 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0194 | 0.0195 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a002e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0196 | 0.0197 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a002e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0198 | 0.0201 | 0.00023 | select * from WebCategoryAttributes
where category = '0005003a0015'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0201 | 0.0202 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0015'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0203 | 0.0204 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0015'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0204 | 0.0205 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a0030'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0205 | 0.0207 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0030'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0207 | 0.0208 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0030'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0208 | 0.0209 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a0033'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0210 | 0.0211 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0033'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0211 | 0.0212 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0033'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0213 | 0.0214 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a0034'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0214 | 0.0215 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0034'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0215 | 0.0217 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0034'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0217 | 0.0218 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a0035'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0218 | 0.0220 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0220 | 0.0221 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0222 | 0.0223 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003a0036'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0223 | 0.0224 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a0036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0225 | 0.0226 | 0.00017 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a0036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0226 | 0.0228 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003e001d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0228 | 0.0229 | 0.00013 | select * from WebCategoryAttributes
where category = '0005003e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0229 | 0.0231 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0231 | 0.0232 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0232 | 0.0233 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e000c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0234 | 0.0235 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0235 | 0.0236 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0236 | 0.0238 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e0003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0238 | 0.0239 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0239 | 0.0241 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0241 | 0.0242 | 0.00013 | select * from WebCategoryAttributes
where category = '0005003e001f'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0243 | 0.0244 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e001f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0244 | 0.0245 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e001f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0246 | 0.0247 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e0004'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0247 | 0.0248 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0249 | 0.0250 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0250 | 0.0251 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003e0005'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0251 | 0.0253 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0253 | 0.0254 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0254 | 0.0255 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e0006'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0255 | 0.0257 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0257 | 0.0258 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0258 | 0.0260 | 0.00014 | select * from WebCategoryAttributes
where category = '0005003e0007'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0260 | 0.0261 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0261 | 0.0263 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0263 | 0.0264 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003e0011'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0264 | 0.0265 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0265 | 0.0267 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0267 | 0.0268 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003e0009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0268 | 0.0270 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0270 | 0.0271 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0271 | 0.0273 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e0017'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0274 | 0.0275 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e0017'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0275 | 0.0277 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e0017'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0277 | 0.0278 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003e001a'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0278 | 0.0280 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e001a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0280 | 0.0281 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e001a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0281 | 0.0282 | 0.00012 | select * from WebCategoryAttributes
where category = '000500210001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0283 | 0.0284 | 0.00018 | select * from WebCategoryAttributes
where category = '00050021'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0285 | 0.0286 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0286 | 0.0288 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0288 | 0.0289 | 0.00011 | select * from WebCategoryAttributes
where category = '000500210017'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0289 | 0.0290 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210017'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0291 | 0.0292 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210017'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0292 | 0.0303 | 0.0011 | select * from WebCategoryAttributes
where category = '000500210018'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0303 | 0.0305 | 0.0002 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210018'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0305 | 0.0307 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210018'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0307 | 0.0308 | 0.00012 | select * from WebCategoryAttributes
where category = '00050021000d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0308 | 0.0310 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050021000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0310 | 0.0311 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050021000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0311 | 0.0312 | 0.00013 | select * from WebCategoryAttributes
where category = '00050021000e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0313 | 0.0314 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050021000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0314 | 0.0316 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050021000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0316 | 0.0317 | 0.00012 | select * from WebCategoryAttributes
where category = '000500210005'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0317 | 0.0318 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0319 | 0.0320 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0320 | 0.0321 | 0.00013 | select * from WebCategoryAttributes
where category = '000500210007'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0322 | 0.0323 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0323 | 0.0324 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0325 | 0.0326 | 0.00015 | select * from WebCategoryAttributes
where category = '000500210012'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0326 | 0.0328 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210012'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0328 | 0.0329 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210012'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0329 | 0.0331 | 0.00012 | select * from WebCategoryAttributes
where category = '000500210008'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0331 | 0.0332 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0332 | 0.0333 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0334 | 0.0335 | 0.00012 | select * from WebCategoryAttributes
where category = '000500210009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0335 | 0.0336 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0336 | 0.0338 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0338 | 0.0339 | 0.00013 | select * from WebCategoryAttributes
where category = '000500210014'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0339 | 0.0341 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500210014'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0341 | 0.0342 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500210014'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0343 | 0.0344 | 0.00012 | select * from WebCategoryAttributes
where category = '00050040000d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0344 | 0.0345 | 0.00012 | select * from WebCategoryAttributes
where category = '00050040'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0345 | 0.0347 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050040000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0347 | 0.0348 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050040000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0348 | 0.0350 | 0.00012 | select * from WebCategoryAttributes
where category = '000500400014'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0350 | 0.0351 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500400014'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0352 | 0.0353 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500400014'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0353 | 0.0354 | 0.00012 | select * from WebCategoryAttributes
where category = '000500400011'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0356 | 0.0357 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500400011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0357 | 0.0359 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500400011'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0359 | 0.0360 | 0.00014 | select * from WebCategoryAttributes
where category = '00050040000e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0360 | 0.0362 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050040000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0362 | 0.0363 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050040000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0363 | 0.0364 | 0.00011 | select * from WebCategoryAttributes
where category = '00050040000f'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0365 | 0.0366 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050040000f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0366 | 0.0367 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050040000f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0368 | 0.0369 | 0.00011 | select * from WebCategoryAttributes
where category = '000500400010'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0369 | 0.0370 | 0.00013999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500400010'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0370 | 0.0372 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500400010'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0372 | 0.0373 | 0.00012 | select * from WebCategoryAttributes
where category = '000500400012'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0373 | 0.0375 | 0.00013999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500400012'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0375 | 0.0376 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500400012'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0376 | 0.0378 | 0.00014 | select * from WebCategoryAttributes
where category = '0005003b001b'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0378 | 0.0379 | 0.00013 | select * from WebCategoryAttributes
where category = '0005003b'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0379 | 0.0381 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003b001b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0381 | 0.0382 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003b001b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0382 | 0.0383 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003b001c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0384 | 0.0385 | 0.00013000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003b001c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0385 | 0.0386 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003b001c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0387 | 0.0388 | 0.00015 | select * from WebCategoryAttributes
where category = '0005003b001e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0388 | 0.0390 | 0.00015999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003b001e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0390 | 0.0391 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003b001e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0391 | 0.0393 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003b0021'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0393 | 0.0394 | 0.00013999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003b0021'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0394 | 0.0396 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003b0021'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0396 | 0.0397 | 0.00013 | select * from WebCategoryAttributes
where category = '0005003c0032'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0398 | 0.0399 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0399 | 0.0400 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0032'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0401 | 0.0402 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0032'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0402 | 0.0403 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c0033'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0403 | 0.0405 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0033'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0405 | 0.0406 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0033'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0406 | 0.0407 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c0034'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0408 | 0.0409 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0034'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0409 | 0.0410 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0034'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0410 | 0.0411 | 0.00011000000000001 | select * from WebCategoryAttributes
where category = '0005003c0035'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0412 | 0.0413 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0413 | 0.0414 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0415 | 0.0416 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c0036'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0416 | 0.0417 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0418 | 0.0419 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0419 | 0.0420 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c0037'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0420 | 0.0422 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0037'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0422 | 0.0424 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0037'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0424 | 0.0425 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '0005003c0038'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0426 | 0.0428 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0038'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0428 | 0.0429 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0038'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0429 | 0.0431 | 0.00013 | select * from WebCategoryAttributes
where category = '0005003c0039'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0431 | 0.0432 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c0039'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0433 | 0.0434 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c0039'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0434 | 0.0436 | 0.00021 | select * from WebCategoryAttributes
where category = '0005003c003a'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0436 | 0.0438 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c003a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0438 | 0.0439 | 0.00013999999999999 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c003a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0440 | 0.0441 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c003b'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0441 | 0.0442 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c003b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0442 | 0.0444 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c003b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0444 | 0.0445 | 0.00011 | select * from WebCategoryAttributes
where category = '0005003c003c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0445 | 0.0447 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c003c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0447 | 0.0448 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c003c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0448 | 0.0449 | 0.00012 | select * from WebCategoryAttributes
where category = '0005003c003d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0449 | 0.0451 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c003d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0451 | 0.0452 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c003d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0452 | 0.0454 | 0.00018 | select * from WebCategoryAttributes
where category = '0005003c003e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0454 | 0.0456 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c003e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0456 | 0.0457 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c003e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0458 | 0.0459 | 0.00016 | select * from WebCategoryAttributes
where category = '000500770002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0459 | 0.0461 | 0.00014 | select * from WebCategoryAttributes
where category = '00050077'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0461 | 0.0463 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500770002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0463 | 0.0464 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500770002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0464 | 0.0466 | 0.00012 | select * from WebCategoryAttributes
where category = '00050077002d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0466 | 0.0467 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050077002d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0467 | 0.0468 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050077002d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0469 | 0.0470 | 0.00012 | select * from WebCategoryAttributes
where category = '00050077002e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0470 | 0.0471 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050077002e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0472 | 0.0473 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050077002e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0473 | 0.0476 | 0.00034 | select * from WebCategoryAttributes
where category = '00050077002f'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0476 | 0.0478 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050077002f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0478 | 0.0480 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050077002f'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0480 | 0.0481 | 0.00014 | select * from WebCategoryAttributes
where category = '000500770031'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0481 | 0.0483 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500770031'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0483 | 0.0484 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500770031'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0485 | 0.0486 | 0.00014 | select * from WebCategoryAttributes
where category = '000500770032'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0486 | 0.0488 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500770032'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0488 | 0.0489 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500770032'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0489 | 0.0491 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '000500360001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0491 | 0.0492 | 0.00013 | select * from WebCategoryAttributes
where category = '00050036'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0492 | 0.0494 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500360001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0494 | 0.0495 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500360001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0495 | 0.0497 | 0.00014 | select * from WebCategoryAttributes
where category = '000500360002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0497 | 0.0499 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500360002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0499 | 0.0500 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500360002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0500 | 0.0502 | 0.00015 | select * from WebCategoryAttributes
where category = '000500360003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0503 | 0.0504 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500360003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0504 | 0.0506 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500360003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0506 | 0.0507 | 0.00013 | select * from WebCategoryAttributes
where category = '000500360007'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0507 | 0.0509 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500360007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0509 | 0.0511 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500360007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0511 | 0.0512 | 0.00013999999999999 | select * from WebCategoryAttributes
where category = '000500350022'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0512 | 0.0514 | 0.00012 | select * from WebCategoryAttributes
where category = '00050035'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0514 | 0.0515 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350022'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0516 | 0.0517 | 0.00014 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500350022'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0517 | 0.0519 | 0.00013 | select * from WebCategoryAttributes
where category = '000500350023'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0519 | 0.0520 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350023'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0520 | 0.0522 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500350023'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0522 | 0.0523 | 0.00013 | select * from WebCategoryAttributes
where category = '000500350024'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0523 | 0.0525 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0525 | 0.0527 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '000500370001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0527 | 0.0528 | 0.00015 | select * from WebCategoryAttributes
where category = '00050037'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0528 | 0.0530 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500370001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0530 | 0.0532 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500370001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0532 | 0.0533 | 0.00014 | select * from WebCategoryAttributes
where category = '00050037000b'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0533 | 0.0535 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050037000b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0535 | 0.0536 | 0.00013999999999999 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050037000b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0537 | 0.0538 | 0.00015 | select * from WebCategoryAttributes
where category = '000500370009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0538 | 0.0540 | 0.00018000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500370009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0540 | 0.0542 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500370009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0542 | 0.0543 | 0.00013 | select * from WebCategoryAttributes
where category = '00050037000c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0543 | 0.0545 | 0.00015999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050037000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0545 | 0.0546 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050037000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0547 | 0.0548 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '00050037000d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0548 | 0.0550 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050037000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0550 | 0.0551 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050037000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0551 | 0.0553 | 0.00015 | select * from WebCategoryAttributes
where category = '000500370002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0553 | 0.0555 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500370002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0555 | 0.0556 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500370002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0556 | 0.0558 | 0.00013 | select * from WebCategoryAttributes
where category = '000500370007'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0558 | 0.0560 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500370007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0560 | 0.0561 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500370007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0561 | 0.0562 | 0.00012 | select * from WebCategoryAttributes
where category = '00050037000e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0563 | 0.0564 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050037000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0564 | 0.0565 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050037000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0565 | 0.0567 | 0.00011 | select * from WebCategoryAttributes
where category = '000500380001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0567 | 0.0568 | 0.0001 | select * from WebCategoryAttributes
where category = '00050038'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0568 | 0.0569 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0570 | 0.0571 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0572 | 0.0573 | 0.00012 | select * from WebCategoryAttributes
where category = '000500380007'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0573 | 0.0575 | 0.00013999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0575 | 0.0576 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0576 | 0.0577 | 0.00012 | select * from WebCategoryAttributes
where category = '000500380004'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0578 | 0.0579 | 0.00016 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0579 | 0.0581 | 0.00013 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0581 | 0.0582 | 0.00014 | select * from WebCategoryAttributes
where category = '000500380003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0582 | 0.0584 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0584 | 0.0585 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0586 | 0.0587 | 0.00012 | select * from WebCategoryAttributes
where category = '000500380006'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0587 | 0.0588 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0588 | 0.0590 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0590 | 0.0591 | 0.00012 | select * from WebCategoryAttributes
where category = '00050038000b'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0591 | 0.0592 | 0.00013 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050038000b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0593 | 0.0594 | 0.00011000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050038000b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0594 | 0.0595 | 0.00013 | select * from WebCategoryAttributes
where category = '000500380008'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0595 | 0.0597 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500380008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0597 | 0.0598 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500380008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0598 | 0.0600 | 0.00012 | select * from WebCategoryAttributes
where category = '0005006e0001'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0600 | 0.0601 | 0.00011 | select * from WebCategoryAttributes
where category = '0005006e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0601 | 0.0602 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005006e0001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0603 | 0.0604 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005006e0001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0604 | 0.0605 | 0.00012 | select * from WebCategoryAttributes
where category = '0005006e0002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0605 | 0.0607 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005006e0002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0607 | 0.0608 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005006e0002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0608 | 0.0610 | 0.00012 | select * from WebCategoryAttributes
where category = '0005006e0003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0610 | 0.0611 | 0.00013999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005006e0003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0611 | 0.0613 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005006e0003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0613 | 0.0614 | 0.00012 | select * from WebCategoryAttributes
where category = '0005006e0004'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0614 | 0.0615 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005006e0004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0616 | 0.0617 | 0.0001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005006e0004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0617 | 0.0618 | 0.00012 | select * from WebCategoryAttributes
where category = '000500220002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0618 | 0.0619 | 0.00013 | select * from WebCategoryAttributes
where category = '00050022'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0620 | 0.0621 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0621 | 0.0623 | 0.00016 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0623 | 0.0624 | 0.00012 | select * from WebCategoryAttributes
where category = '000500220008'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0625 | 0.0626 | 0.00013000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0626 | 0.0627 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220008'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0628 | 0.0629 | 0.00014 | select * from WebCategoryAttributes
where category = '000500220003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0629 | 0.0631 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0631 | 0.0632 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0632 | 0.0635 | 0.00025 | select * from WebCategoryAttributes
where category = '000500220004'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0635 | 0.0637 | 0.00016000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0637 | 0.0638 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220004'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0638 | 0.0639 | 0.00011 | select * from WebCategoryAttributes
where category = '000500220005'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0639 | 0.0641 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0641 | 0.0642 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0645 | 0.0646 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '000500220006'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0647 | 0.0648 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0648 | 0.0649 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220006'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0650 | 0.0651 | 0.00011 | select * from WebCategoryAttributes
where category = '000500220009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0651 | 0.0652 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500220009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0653 | 0.0654 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500220009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0654 | 0.0655 | 0.00012 | select * from WebCategoryAttributes
where category = '000500270009'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0655 | 0.0657 | 0.00012 | select * from WebCategoryAttributes
where category = '00050027'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0657 | 0.0659 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500270009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0659 | 0.0660 | 0.00015000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500270009'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0661 | 0.0662 | 0.00014 | select * from WebCategoryAttributes
where category = '00050027000a'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0662 | 0.0664 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050027000a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0664 | 0.0665 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050027000a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0665 | 0.0666 | 0.00012 | select * from WebCategoryAttributes
where category = '00050027000c'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0666 | 0.0668 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050027000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0668 | 0.0669 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050027000c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0669 | 0.0670 | 0.00011000000000001 | select * from WebCategoryAttributes
where category = '00050027000d'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0671 | 0.0672 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050027000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0672 | 0.0673 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050027000d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0674 | 0.0675 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '000500270002'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0675 | 0.0677 | 0.00015999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500270002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0677 | 0.0678 | 0.00012999999999999 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500270002'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0679 | 0.0680 | 0.00013000000000001 | select * from WebCategoryAttributes
where category = '00050027000e'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0680 | 0.0681 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050027000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0682 | 0.0683 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050027000e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0683 | 0.0685 | 0.00012 | select * from WebCategoryAttributes
where category = '000500270003'
and attribute = '4'
and value_ != "" LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7567 | isCatAvail |
0.0685 | 0.0686 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500270003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0686 | 0.0688 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '000500270003'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0690 | 0.0741 | 0.0052 | SELECT cref FROM WebBudgets WHERE cref = 'WEB003' AND YEAR(yearstartdate) = '2024' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/budgetApprovalClass.php line 789 | customerHasBudget |
0.0742 | 0.0744 | 0.00021 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.0744 | 0.0746 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050083'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0747 | 0.0748 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050083'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0748 | 0.0750 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050020'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0750 | 0.0751 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050020'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0751 | 0.0753 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0753 | 0.0754 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003a'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0754 | 0.0756 | 0.00016000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0756 | 0.0757 | 0.00012000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0758 | 0.0759 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050021'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0759 | 0.0761 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050021'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0761 | 0.0762 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050040'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0763 | 0.0764 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050040'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0764 | 0.0765 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0766 | 0.0767 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003b'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0767 | 0.0768 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0769 | 0.0770 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005003c'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0772 | 0.0773 | 0.00015 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050077'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0773 | 0.0775 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050077'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0775 | 0.0776 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0776 | 0.0778 | 0.00013000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050036'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0778 | 0.0779 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0780 | 0.0781 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050037'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0781 | 0.0782 | 0.00011 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050037'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0782 | 0.0784 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050038'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0784 | 0.0786 | 0.00012 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050038'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0786 | 0.0787 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005006e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0787 | 0.0789 | 0.00012000000000001 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005006e'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0789 | 0.0790 | 0.00013000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050022'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0790 | 0.0792 | 0.00015 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050022'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0792 | 0.0795 | 0.00031999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050027'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0795 | 0.0797 | 0.00018 | select ca.alias from WebCategoryAliases as ca
where ca.category = '00050027'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.0798 | 0.0799 | 0.00016000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.0799 | 0.0801 | 0.00017 | SELECT * FROM WebAttributes WHERE aname = ':availableto' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/pageData.php line 141 | allProductsQuery |
0.0801 | 0.0826 | 0.0025 |
SELECT * FROM
((SELECT 'category' AS type, c.category, cp.stockcode AS stockcode, pp.sellprc1 AS listprice, pp.sellprc1, c.ctitle AS title, p.sold AS bestselling, cp.lstorder, c.lstorder AS catlstorder
FROM WebCategories AS c
LEFT JOIN WebCategoryAliases AS ca ON ca.category = c.category
LEFT JOIN WebCategoryProducts AS cp ON( cp.category = c.category )
LEFT JOIN WebProducts AS p ON ( cp.stockcode=p.stockcode )
LEFT JOIN WebProductPrices AS pp ON ( cp.stockcode = pp.stockcode )
LEFT JOIN WebCategoryAttributes AS wca ON c.category = wca.category AND attribute = '4'
WHERE length(c.category)=24 and SUBSTRING(c.category,1,20) = '00050035002400070001' and c.visible='Y' and grpproducts='Y' AND (wca.value_ = '' OR wca.value_ IS NULL OR wca.value_ LIKE '%WEB003%') GROUP BY c.category )
UNION
(SELECT 'product' AS type, cp.category, cp.stockcode, pp.sellprc1 AS listprice, pp.sellprc1, p.description AS title, p.sold AS bestselling, cp.lstorder, NULL AS catlstorder
FROM WebCategoryProducts AS cp
LEFT JOIN WebProducts AS p ON cp.stockcode=p.stockcode
LEFT JOIN WebCategoryAliases AS ca ON ca.category = cp.category
LEFT JOIN WebProductPrices AS pp ON ( p.stockcode = pp.stockcode )
LEFT JOIN WebProductAttributes AS wpa ON cp.stockcode = wpa.stockcode AND attribute = '4'
WHERE cp.category='00050035002400070001' AND p.visible='Y' AND (wpa.value_ = '' OR wpa.value_ IS NULL OR wpa.value_ LIKE '%WEB003%') )) AS tbl | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/pageData.php line 107 | queryDatabase |
0.0828 | 0.0830 | 0.00026 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='0005' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0831 | 0.0832 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0833 | 0.0835 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0835 | 0.0837 | 0.00019 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='00050035' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0837 | 0.0838 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0839 | 0.0840 | 0.00016000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0840 | 0.0842 | 0.00018 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='000500350024' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0842 | 0.0844 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0844 | 0.0846 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0846 | 0.0848 | 0.00019999999999999 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='0005003500240007' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0848 | 0.0850 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003500240007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0850 | 0.0851 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005003500240007'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0851 | 0.0853 | 0.00019 |
select c.category,c.ctitle,c.shorttitle,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where c.category='00050035002400070001' and visible='Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2731 | getBreadCrumbTrail |
0.0853 | 0.0855 | 0.00019 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0855 | 0.0857 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.0860 | 0.0864 | 0.00037999999999999 | SELECT wc.category as category
FROM WebCategories wc
INNER JOIN WebCategoryAttributes wca ON wc.category=wca.category
INNER JOIN WebAttributes wa ON wca.attribute=wa.code
WHERE wa.aname='Best seller'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 9535 | queryCategoriesEmphasised |
0.0864 | 0.0883 | 0.0019 |
select c.category,c.ctitle,c.shorttitle,c.description,c.imgfilename,ca.alias,grpproducts from WebCategories as c
left join WebCategoryAliases as ca on ca.category = c.category
where length(c.category)=24 and SUBSTRING(c.category,1,20) = '00050035002400070001' and visible='Y' and grpproducts<>'Y'
order by lstorder,ctitle
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 2994 | queryCategories |
0.0883 | 0.0885 | 0.00019999999999999 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.0885 | 0.0886 | 0.00014 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05802' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.0886 | 0.0959 | 0.0073 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.0960 | 0.0964 | 0.00044000000000001 |
select p.* from WebProducts as p
where p.stockcode = 'PC05802' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.0964 | 0.0980 | 0.0016 | SELECT * FROM STStockDetails WHERE stcode = 'PC05802' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.0980 | 0.0982 | 0.00015999999999999 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.0982 | 0.0984 | 0.00019 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.0984 | 0.0986 | 0.00020000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.0986 | 0.0989 | 0.00026000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.0989 | 0.0990 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.0991 | 0.0992 | 0.00015999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.0992 | 0.0994 | 0.00015000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.0994 | 0.0996 | 0.00018 |
select * from WebProductPrices as sp
where sp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.0996 | 0.0997 | 0.00015 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.0997 | 0.0999 | 0.00013000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.0999 | 0.1000 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1000 | 0.1002 | 0.00019000000000001 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1002 | 0.1004 | 0.00020000000000001 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1005 | 0.1006 | 0.00017 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1006 | 0.1008 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1008 | 0.1009 | 0.00015000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1009 | 0.1011 | 0.00019999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1011 | 0.1013 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1013 | 0.1014 | 0.00015 |
select * from WebProductPrices as sp
where sp.stockcode='PC05802'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1014 | 0.1016 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1016 | 0.1017 | 0.00015 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1018 | 0.1020 | 0.00025 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1021 | 0.1023 | 0.00026999999999999 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05802' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1023 | 0.1025 | 0.00012999999999999 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1025 | 0.1026 | 0.00014 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1026 | 0.1028 | 0.00012999999999999 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1028 | 0.1029 | 0.00011 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1029 | 0.1030 | 0.00012000000000001 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1030 | 0.1031 | 0.0001 | select p.description from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1031 | 0.1033 | 0.00017 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1033 | 0.1035 | 0.00015999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1035 | 0.1037 | 0.00018 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05802'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1037 | 0.1039 | 0.00013999999999999 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05802' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1039 | 0.1040 | 0.00015999999999999 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05802'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1041 | 0.1042 | 0.00016999999999999 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1042 | 0.1044 | 0.00012999999999999 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05802' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1044 | 0.1100 | 0.0057 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1101 | 0.1104 | 0.00027000000000001 |
select p.* from WebProducts as p
where p.stockcode = 'PC05802' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1105 | 0.1106 | 0.00015999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05802' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1106 | 0.1108 | 0.00015 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1108 | 0.1109 | 0.00012 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1116 | 0.1117 | 0.00018 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1118 | 0.1119 | 0.00011 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05805' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1119 | 0.1168 | 0.0049 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1168 | 0.1170 | 0.00023000000000001 |
select p.* from WebProducts as p
where p.stockcode = 'PC05805' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.1171 | 0.1174 | 0.00036000000000001 | SELECT * FROM STStockDetails WHERE stcode = 'PC05805' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.1175 | 0.1176 | 0.00012 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.1176 | 0.1178 | 0.00017 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.1178 | 0.1180 | 0.00018 |
select * from WebProductPrices as sp
where sp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.1180 | 0.1183 | 0.00023999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1183 | 0.1184 | 0.00013000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1184 | 0.1186 | 0.00015 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1186 | 0.1187 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.1187 | 0.1189 | 0.00015 |
select * from WebProductPrices as sp
where sp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.1189 | 0.1190 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1190 | 0.1191 | 0.0001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1191 | 0.1193 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1193 | 0.1194 | 0.00011 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1194 | 0.1195 | 0.00014 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1196 | 0.1197 | 0.00015 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1197 | 0.1203 | 0.00059000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1203 | 0.1205 | 0.00018 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1205 | 0.1206 | 0.00012 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1207 | 0.1208 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1208 | 0.1209 | 0.00016000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='PC05805'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1210 | 0.1211 | 0.00012 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1211 | 0.1212 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1213 | 0.1214 | 0.00018 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1215 | 0.1217 | 0.00023000000000001 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05805' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1217 | 0.1218 | 0.00011 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1218 | 0.1219 | 9.0000000000007E-5 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1219 | 0.1220 | 0.0001 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1220 | 0.1221 | 0.00011 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1222 | 0.1223 | 0.00011 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1223 | 0.1224 | 0.00011 | select p.description from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1224 | 0.1225 | 0.00013000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1226 | 0.1227 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1228 | 0.1229 | 0.00011 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05805'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1229 | 0.1230 | 0.00012 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05805' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1230 | 0.1232 | 0.00012999999999999 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05805'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1232 | 0.1233 | 0.00013000000000001 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1233 | 0.1234 | 0.00011 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05805' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1234 | 0.1285 | 0.0051 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1286 | 0.1288 | 0.00025999999999998 |
select p.* from WebProducts as p
where p.stockcode = 'PC05805' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1289 | 0.1290 | 0.00015999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05805' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1291 | 0.1292 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1292 | 0.1294 | 0.00012000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1294 | 0.1296 | 0.00015000000000001 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1296 | 0.1297 | 0.00011 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05810' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1297 | 0.1356 | 0.0058 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1356 | 0.1360 | 0.00034999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05810' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.1360 | 0.1364 | 0.00036 | SELECT * FROM STStockDetails WHERE stcode = 'PC05810' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.1364 | 0.1365 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.1366 | 0.1367 | 0.00015000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.1367 | 0.1369 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.1369 | 0.1370 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1371 | 0.1372 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1372 | 0.1374 | 0.00016000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1374 | 0.1375 | 0.00011000000000003 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.1376 | 0.1377 | 0.00014 |
select * from WebProductPrices as sp
where sp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.1377 | 0.1378 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1379 | 0.1380 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1380 | 0.1381 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1381 | 0.1383 | 0.00014 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1383 | 0.1384 | 0.00015000000000001 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1385 | 0.1386 | 0.00013000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1386 | 0.1387 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1387 | 0.1389 | 0.00013000000000002 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1389 | 0.1390 | 0.00012000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1390 | 0.1391 | 0.00011999999999998 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1391 | 0.1393 | 0.00014999999999998 |
select * from WebProductPrices as sp
where sp.stockcode='PC05810'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1393 | 0.1395 | 0.00017 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1395 | 0.1396 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1397 | 0.1398 | 0.00017999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1399 | 0.1401 | 0.00022 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05810' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1401 | 0.1402 | 0.00012000000000001 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1402 | 0.1403 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1403 | 0.1404 | 9.0000000000007E-5 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1404 | 0.1405 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1406 | 0.1407 | 9.9999999999989E-5 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1407 | 0.1408 | 9.0000000000007E-5 | select p.description from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1408 | 0.1409 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1409 | 0.1411 | 0.00019 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1412 | 0.1413 | 0.00012000000000001 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05810'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1413 | 0.1415 | 0.00011 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05810' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1415 | 0.1416 | 0.00012999999999999 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05810'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1416 | 0.1418 | 0.00015000000000001 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1418 | 0.1419 | 0.00012000000000001 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05810' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1419 | 0.1471 | 0.0051 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1471 | 0.1473 | 0.00025 |
select p.* from WebProducts as p
where p.stockcode = 'PC05810' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1474 | 0.1476 | 0.00015999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05810' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1476 | 0.1478 | 0.00016000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1478 | 0.1479 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1480 | 0.1482 | 0.00015999999999999 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1482 | 0.1483 | 0.00013000000000002 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05815' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1483 | 0.1533 | 0.0050 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1534 | 0.1536 | 0.00024000000000002 |
select p.* from WebProducts as p
where p.stockcode = 'PC05815' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.1536 | 0.1540 | 0.00037999999999999 | SELECT * FROM STStockDetails WHERE stcode = 'PC05815' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.1540 | 0.1542 | 0.00015000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.1542 | 0.1544 | 0.00017 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.1544 | 0.1545 | 0.00016000000000002 |
select * from WebProductPrices as sp
where sp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.1546 | 0.1547 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1547 | 0.1548 | 0.00011000000000003 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1549 | 0.1550 | 0.00015000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1550 | 0.1551 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.1552 | 0.1553 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.1553 | 0.1555 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1555 | 0.1556 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1556 | 0.1557 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1557 | 0.1559 | 0.00012000000000001 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1559 | 0.1560 | 0.00016000000000002 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1561 | 0.1562 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1562 | 0.1563 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1563 | 0.1565 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1565 | 0.1566 | 0.00011999999999998 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1566 | 0.1567 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1568 | 0.1569 | 0.00015999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='PC05815'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1569 | 0.1571 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1571 | 0.1572 | 9.9999999999989E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1572 | 0.1574 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1574 | 0.1577 | 0.00023000000000001 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05815' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1577 | 0.1578 | 0.00011000000000003 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1578 | 0.1579 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1579 | 0.1580 | 9.0000000000007E-5 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1580 | 0.1582 | 0.00017999999999999 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1582 | 0.1583 | 0.00010000000000002 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1583 | 0.1584 | 0.00011 | select p.description from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1585 | 0.1586 | 0.00013000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1586 | 0.1587 | 0.00013000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1588 | 0.1589 | 0.00010000000000002 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05815'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1589 | 0.1590 | 0.00011 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05815' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1590 | 0.1592 | 0.00013000000000002 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05815'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1592 | 0.1593 | 0.00014 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1594 | 0.1595 | 0.00010000000000002 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05815' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1595 | 0.1646 | 0.0052 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1647 | 0.1650 | 0.00029999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05815' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1650 | 0.1652 | 0.00017 |
select p.* from WebProducts as p
where p.stockcode = 'PC05815' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1652 | 0.1654 | 0.00016000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1654 | 0.1655 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1658 | 0.1659 | 0.00017 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1659 | 0.1661 | 0.00011 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05820' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1661 | 0.1710 | 0.0049 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1710 | 0.1712 | 0.00022999999999998 |
select p.* from WebProducts as p
where p.stockcode = 'PC05820' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.1713 | 0.1717 | 0.00039999999999998 | SELECT * FROM STStockDetails WHERE stcode = 'PC05820' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.1717 | 0.1718 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.1719 | 0.1720 | 0.00014999999999998 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.1720 | 0.1722 | 0.00014999999999998 |
select * from WebProductPrices as sp
where sp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.1722 | 0.1723 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1723 | 0.1724 | 0.00010000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1725 | 0.1726 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1726 | 0.1727 | 0.00010000000000002 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.1727 | 0.1729 | 0.00017 |
select * from WebProductPrices as sp
where sp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.1729 | 0.1730 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1731 | 0.1732 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1732 | 0.1733 | 0.00013000000000002 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1733 | 0.1735 | 0.00013000000000002 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1735 | 0.1736 | 0.00014 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1736 | 0.1738 | 0.00017 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1738 | 0.1740 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1740 | 0.1741 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1741 | 0.1743 | 0.00014 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1743 | 0.1744 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1744 | 0.1746 | 0.00016000000000002 |
select * from WebProductPrices as sp
where sp.stockcode='PC05820'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1746 | 0.1747 | 0.00010000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1747 | 0.1748 | 0.00011000000000003 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1749 | 0.1750 | 0.00015999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1751 | 0.1753 | 0.00023000000000001 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05820' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1753 | 0.1754 | 0.00011 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1754 | 0.1755 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1755 | 0.1757 | 0.00011 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1757 | 0.1758 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1758 | 0.1759 | 0.00014999999999998 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1759 | 0.1760 | 9.9999999999989E-5 | select p.description from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1761 | 0.1762 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1762 | 0.1764 | 0.00013000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1764 | 0.1766 | 0.00014 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05820'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1766 | 0.1767 | 0.00012000000000001 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05820' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1767 | 0.1768 | 0.00012999999999999 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05820'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1769 | 0.1770 | 0.00015000000000001 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1770 | 0.1771 | 0.00010000000000002 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05820' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1771 | 0.1821 | 0.0050 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1821 | 0.1824 | 0.00023999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05820' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1824 | 0.1826 | 0.00017 |
select p.* from WebProducts as p
where p.stockcode = 'PC05820' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1827 | 0.1828 | 0.00014999999999998 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1828 | 0.1830 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1830 | 0.1832 | 0.00018000000000001 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1832 | 0.1834 | 0.00012000000000001 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05900' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1834 | 0.1882 | 0.0048 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1882 | 0.1884 | 0.00020000000000001 |
select p.* from WebProducts as p
where p.stockcode = 'PC05900' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 11224 | addProductToBasketButton |
0.1884 | 0.1889 | 0.00046000000000002 | SELECT * FROM STStockDetails WHERE stcode = 'PC05900' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.1889 | 0.1891 | 0.00013000000000002 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.1891 | 0.1892 | 0.00015999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.1893 | 0.1894 | 0.00017999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.1895 | 0.1896 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1896 | 0.1897 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1898 | 0.1899 | 0.00014 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1899 | 0.1900 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.1900 | 0.1902 | 0.00014 |
select * from WebProductPrices as sp
where sp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.1902 | 0.1903 | 9.9999999999989E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1903 | 0.1904 | 9.0000000000007E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1904 | 0.1905 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.1906 | 0.1907 | 0.00011 |
select * from WebPromotionalPrices as pp
where pp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.1907 | 0.1908 | 0.00014 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.1908 | 0.1910 | 0.00013000000000002 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1910 | 0.1911 | 9.9999999999989E-5 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.1911 | 0.1912 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.1912 | 0.1914 | 0.00011999999999998 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.1914 | 0.1915 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1915 | 0.1916 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='PC05900'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.1917 | 0.1918 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1918 | 0.1919 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.1920 | 0.1921 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035002400070001'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.1922 | 0.1924 | 0.00023000000000001 | select cp.stockcode,cp.category from WebCategoryProducts as cp
left join WebProducts as p on p.stockcode = cp.stockcode
left join WebCategories as c on c.category = cp.category
where p.stockcode = 'PC05900' and p.visible='Y' and c.visible='Y'
ORDER BY c.category DESC
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1232 | getProductCategory |
0.1924 | 0.1925 | 0.00012000000000001 | select c.visible from WebCategories as c
where c.category='0005003500240007' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1925 | 0.1926 | 9.9999999999989E-5 | select c.visible from WebCategories as c
where c.category='000500350024' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1926 | 0.1928 | 0.00011 | select c.visible from WebCategories as c
where c.category='00050035' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1928 | 0.1929 | 0.00010000000000002 | select c.visible from WebCategories as c
where c.category='0005' and c.visible='Y'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1251 | getProductCategory |
0.1929 | 0.1930 | 9.9999999999989E-5 | select p.imgfilename from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.1930 | 0.1931 | 9.9999999999989E-5 | select p.description from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1117 | getProductDesc |
0.1931 | 0.1932 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1932 | 0.1934 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1934 | 0.1935 | 0.00010000000000002 | select p.availability,p.stocklevel,p.leadtime from WebProducts as p
where p.stockcode = 'PC05900'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7257 | getProductAvailability |
0.1936 | 0.1937 | 0.00011 | SELECT leadtime1 FROM STStockDetails WHERE stcode='PC05900' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 8780 | productDueDays |
0.1937 | 0.1938 | 0.00013000000000002 | SELECT * FROM WebCustomerPrices WHERE cref = 'WEB003' AND stockcode = 'PC05900'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1938 | 0.1940 | 0.00014 | SELECT COUNT(*) as count FROM WebActicareCustomerProductControls WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1940 | 0.1941 | 0.00011 | SELECT stockcode, status FROM WebActicareCustomerProductControls WHERE cref = 'WEB003' AND stockcode = 'PC05900' LIMIT 1 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1941 | 0.1991 | 0.0050 | SELECT crminvref FROM CRCustomers WHERE cref = 'WEB003'; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 997 | array_query |
0.1992 | 0.1994 | 0.00023999999999999 |
select p.* from WebProducts as p
where p.stockcode = 'PC05900' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/productlist-product.php line 152 | include |
0.1995 | 0.1997 | 0.00017 |
select p.* from WebProducts as p
where p.stockcode = 'PC05900' and visible='Y' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/themes/activerehab/views/product/addprodtobasket-gridview.php line 23 | include |
0.1997 | 0.1998 | 0.00015999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.1999 | 0.2000 | 0.00011999999999998 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2002 | 0.2010 | 0.0008 |
SELECT rp.maincode, rp.relcode, rp.relcodetype, p.*, c.*, p.description as product_title, c.description as category_title FROM WebRelatedProducts AS rp
LEFT JOIN WebProducts AS p ON rp.relcode = p.stockcode
LEFT JOIN WebCategoryAliases AS ca ON rp.relcode = ca.alias
LEFT JOIN WebCategories AS c ON ca.category = c.category
WHERE rp.maincode='hair-care' and (p.visible = 'Y' or c.visible = 'Y') AND rp.reltype = 'option' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3340 | queryRelated |
0.2010 | 0.2017 | 0.00065000000000001 |
SELECT rp.maincode, rp.relcode, rp.relcodetype, p.*, c.*, p.description as product_title, c.description as category_title FROM WebRelatedProducts AS rp
LEFT JOIN WebProducts AS p ON rp.relcode = p.stockcode
LEFT JOIN WebCategoryAliases AS ca ON rp.relcode = ca.alias
LEFT JOIN WebCategories AS c ON ca.category = c.category
WHERE rp.maincode='hair-care' and (p.visible = 'Y' or c.visible = 'Y') AND rp.reltype = 'access' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3340 | queryRelated |
0.2017 | 0.2024 | 0.00070000000000001 |
SELECT rp.maincode, rp.relcode, rp.relcodetype, p.*, c.*, p.description as product_title, c.description as category_title FROM WebRelatedProducts AS rp
LEFT JOIN WebProducts AS p ON rp.relcode = p.stockcode
LEFT JOIN WebCategoryAliases AS ca ON rp.relcode = ca.alias
LEFT JOIN WebCategories AS c ON ca.category = c.category
WHERE rp.maincode='hair-care' and (p.visible = 'Y' or c.visible = 'Y') AND rp.reltype = 'suggest' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3340 | queryRelated |
0.2025 | 0.2026 | 0.00015000000000001 |
select * from WebAlsoBought as ab
where ab.code = '00050035002400070001' and ab.codetype = 'C'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7855 | queryAlsoBought |
0.2027 | 0.2029 | 0.00017999999999999 | SELECT c.category, c.ctitle, c.visible, c.description, c.shorttitle, c.grpproducts, c.lstorder, ca.alias
FROM WebCategories AS c
LEFT JOIN WebCategoryAliases AS ca ON ca.category = c.category
WHERE c.category = '00050035' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 61 | __construct |
0.2029 | 0.2031 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '00050035'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2031 | 0.2033 | 0.00019 | SELECT a.aname, ca.value_ from WebCategoryAttributes AS ca
LEFT JOIN WebAttributes AS a ON ca.attribute = a.code
WHERE ca.category = '00050035'
order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 138 | get_attributes |
0.2033 | 0.2036 | 0.00029000000000001 | SELECT category FROM WebCategories WHERE category LIKE '00050035%' AND length(category) = 4 + 8 order by lstorder,ctitle | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 224 | get_children |
0.2036 | 0.2038 | 0.00016999999999998 | SELECT c.category, c.ctitle, c.visible, c.description, c.shorttitle, c.grpproducts, c.lstorder, ca.alias
FROM WebCategories AS c
LEFT JOIN WebCategoryAliases AS ca ON ca.category = c.category
WHERE c.category = '000500350022' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 61 | __construct |
0.2038 | 0.2040 | 0.00014999999999998 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350022'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2040 | 0.2042 | 0.00017999999999999 | SELECT a.aname, ca.value_ from WebCategoryAttributes AS ca
LEFT JOIN WebAttributes AS a ON ca.attribute = a.code
WHERE ca.category = '000500350022'
order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 138 | get_attributes |
0.2042 | 0.2043 | 0.00016000000000002 | SELECT c.category, c.ctitle, c.visible, c.description, c.shorttitle, c.grpproducts, c.lstorder, ca.alias
FROM WebCategories AS c
LEFT JOIN WebCategoryAliases AS ca ON ca.category = c.category
WHERE c.category = '000500350023' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 61 | __construct |
0.2043 | 0.2045 | 0.00014 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350023'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2045 | 0.2047 | 0.00018000000000001 | SELECT a.aname, ca.value_ from WebCategoryAttributes AS ca
LEFT JOIN WebAttributes AS a ON ca.attribute = a.code
WHERE ca.category = '000500350023'
order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 138 | get_attributes |
0.2047 | 0.2049 | 0.00018000000000001 | SELECT c.category, c.ctitle, c.visible, c.description, c.shorttitle, c.grpproducts, c.lstorder, ca.alias
FROM WebCategories AS c
LEFT JOIN WebCategoryAliases AS ca ON ca.category = c.category
WHERE c.category = '000500350024' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 61 | __construct |
0.2049 | 0.2051 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '000500350024'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2051 | 0.2053 | 0.00017999999999999 | SELECT a.aname, ca.value_ from WebCategoryAttributes AS ca
LEFT JOIN WebAttributes AS a ON ca.attribute = a.code
WHERE ca.category = '000500350024'
order by ca.lstorder | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/Category.php line 138 | get_attributes |
0.2053 | 0.2054 | 0.00015000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2055 | 0.2057 | 0.00015000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2057 | 0.2064 | 0.00068000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2065 | 0.2067 | 0.00025 | Select wp.stockcode,wp.description,wp.imgfilename,wc.ctitle,wcp.category From WebProducts wp
Left Join WebCategoryProducts wcp On wcp.stockcode = wp.stockcode
Left Join WebCategories wc On wc.category = wcp.category
where ctitle = 'Home Page Featured Products' Limit 5 | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 129 | queryTopProducts |
0.2068 | 0.2069 | 0.00012000000000001 | select p.imgfilename from WebProducts as p
where p.stockcode = 'BD620CR'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.2069 | 0.2072 | 0.00035000000000002 | SELECT * FROM STStockDetails WHERE stcode = 'BD620CR' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.2073 | 0.2074 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620CR'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.2074 | 0.2078 | 0.00033999999999998 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.2078 | 0.2080 | 0.00020000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.2080 | 0.2082 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2082 | 0.2083 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2083 | 0.2084 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2085 | 0.2086 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620CR'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.2086 | 0.2087 | 0.00014 |
select * from WebProductPrices as sp
where sp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.2089 | 0.2090 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2091 | 0.2092 | 0.00010000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2092 | 0.2093 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620CR'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.2093 | 0.2094 | 0.00011 |
select * from WebPromotionalPrices as pp
where pp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.2094 | 0.2096 | 0.00015000000000001 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.2096 | 0.2098 | 0.00014999999999998 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2098 | 0.2099 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620CR'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.2099 | 0.2100 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.2100 | 0.2102 | 0.00014 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.2102 | 0.2103 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2103 | 0.2105 | 0.00014 |
select * from WebProductPrices as sp
where sp.stockcode='BD620CR'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.2105 | 0.2106 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2106 | 0.2107 | 9.9999999999989E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2107 | 0.2109 | 0.00015999999999999 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2109 | 0.2110 | 0.00013000000000002 | select ca.alias from WebCategoryAliases as ca
where ca.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 303 | get_category_slug |
0.2111 | 0.2112 | 0.00014 | select p.imgfilename from WebProducts as p
where p.stockcode = 'BD620WH'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.2112 | 0.2116 | 0.00036 | SELECT * FROM STStockDetails WHERE stcode = 'BD620WH' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.2116 | 0.2118 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620WH'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.2118 | 0.2119 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.2119 | 0.2121 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.2121 | 0.2122 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2122 | 0.2123 | 9.9999999999989E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2123 | 0.2125 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2125 | 0.2126 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620WH'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.2126 | 0.2128 | 0.00015999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.2128 | 0.2129 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2129 | 0.2130 | 0.00010000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2130 | 0.2131 | 9.9999999999989E-5 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620WH'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.2131 | 0.2133 | 0.00011 |
select * from WebPromotionalPrices as pp
where pp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.2133 | 0.2134 | 0.00014 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.2134 | 0.2139 | 0.00045999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2139 | 0.2141 | 0.00019 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BD620WH'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.2141 | 0.2143 | 0.00021000000000002 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.2143 | 0.2145 | 0.00012000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.2145 | 0.2146 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2146 | 0.2148 | 0.00015999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='BD620WH'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.2148 | 0.2149 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2149 | 0.2150 | 0.00012999999999999 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2151 | 0.2152 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2153 | 0.2154 | 0.00011 | select p.imgfilename from WebProducts as p
where p.stockcode = 'BE14470'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.2154 | 0.2157 | 0.00033 | SELECT * FROM STStockDetails WHERE stcode = 'BE14470' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.2157 | 0.2159 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE14470'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.2159 | 0.2161 | 0.00017 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.2161 | 0.2162 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.2163 | 0.2164 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2164 | 0.2165 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2165 | 0.2167 | 0.00015000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2167 | 0.2168 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE14470'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.2168 | 0.2170 | 0.00015999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.2170 | 0.2171 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2171 | 0.2172 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2173 | 0.2174 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE14470'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.2174 | 0.2175 | 0.00015999999999999 |
select * from WebPromotionalPrices as pp
where pp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.2176 | 0.2177 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2177 | 0.2179 | 0.00015000000000001 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2181 | 0.2182 | 0.00014 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE14470'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.2182 | 0.2183 | 0.00013000000000002 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.2184 | 0.2185 | 0.00012000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.2185 | 0.2186 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2186 | 0.2188 | 0.00015000000000001 |
select * from WebProductPrices as sp
where sp.stockcode='BE14470'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.2188 | 0.2189 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2189 | 0.2190 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2191 | 0.2193 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2195 | 0.2196 | 0.00013000000000002 | select p.imgfilename from WebProducts as p
where p.stockcode = 'BE15748'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.2196 | 0.2200 | 0.00031 | SELECT * FROM STStockDetails WHERE stcode = 'BE15748' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.2200 | 0.2201 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15748'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.2201 | 0.2202 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.2203 | 0.2205 | 0.00025 |
select * from WebProductPrices as sp
where sp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.2205 | 0.2206 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2207 | 0.2208 | 0.00010000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2208 | 0.2209 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2209 | 0.2210 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15748'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.2210 | 0.2212 | 0.00014 |
select * from WebProductPrices as sp
where sp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.2212 | 0.2213 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2213 | 0.2214 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2215 | 0.2216 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15748'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.2216 | 0.2217 | 0.00011999999999998 |
select * from WebPromotionalPrices as pp
where pp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.2217 | 0.2219 | 0.00013000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2219 | 0.2220 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2220 | 0.2222 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15748'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.2222 | 0.2223 | 0.00016000000000002 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.2224 | 0.2225 | 0.00012000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.2225 | 0.2226 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2226 | 0.2227 | 0.00013000000000002 |
select * from WebProductPrices as sp
where sp.stockcode='BE15748'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.2228 | 0.2229 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2229 | 0.2230 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2230 | 0.2232 | 0.00015000000000001 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2232 | 0.2233 | 9.9999999999989E-5 | select p.imgfilename from WebProducts as p
where p.stockcode = 'BE15910'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 1618 | getProductImageSrc |
0.2233 | 0.2237 | 0.00033999999999998 | SELECT * FROM STStockDetails WHERE stcode = 'BE15910' LIMIT 1; | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 7227 | checkVATDisplay |
0.2237 | 0.2238 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15910'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3575 | getDefaultPrice |
0.2238 | 0.2240 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3662 | getDefaultPrice |
0.2240 | 0.2242 | 0.00022 |
select * from WebProductPrices as sp
where sp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 3780 | getDefaultPrice |
0.2242 | 0.2243 | 0.00013000000000002 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2244 | 0.2245 | 9.9999999999989E-5 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2245 | 0.2246 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2246 | 0.2248 | 0.00011 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15910'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4107 | getBasePrice |
0.2248 | 0.2249 | 0.00015999999999999 |
select * from WebProductPrices as sp
where sp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4194 | getBasePrice |
0.2250 | 0.2251 | 0.00011999999999998 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2251 | 0.2252 | 0.00011999999999998 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2252 | 0.2253 | 0.00012000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15910'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4523 | getPromotionalPrice |
0.2254 | 0.2255 | 0.00011 |
select * from WebPromotionalPrices as pp
where pp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4620 | getPromotionalPrice |
0.2255 | 0.2256 | 0.00013999999999997 |
select * from WebPromotionalLinks as pl
where pl.linkstockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4832 | getPromotionalPrice |
0.2256 | 0.2258 | 0.00012999999999999 | select * from WebCustomers where cref='WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/session.php line 1176 | getSessionCref |
0.2258 | 0.2260 | 0.00018000000000001 | select p.packquantity,p.splitpacks,p.vatcd,p.weight from WebProducts as p
where p.stockcode = 'BE15910'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 4914 | getCustomerPrice |
0.2260 | 0.2261 | 0.00015000000000001 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5001 | getCustomerPrice |
0.2261 | 0.2263 | 0.00012999999999999 |
select * from WebCustomerPrices as cp
where cp.cref='WEB003' and cp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5009 | getCustomerPrice |
0.2263 | 0.2264 | 0.00014 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2264 | 0.2266 | 0.00017 |
select * from WebProductPrices as sp
where sp.stockcode='BE15910'
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/catalogue.php line 5138 | getCustomerPrice |
0.2266 | 0.2268 | 0.00012000000000001 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2268 | 0.2269 | 0.00011 | SELECT retailprc FROM SLCustomers WHERE cref = 'WEB003' | /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/functions.php line 2643 | is_customer_retail |
0.2269 | 0.2271 | 0.00017 | select c.category,c.grpproducts,ca.alias from WebCategories as c
left join WebCategoryAliases as ca on c.category = ca.category
where c.category = '0005001d'
limit 1
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/RewriteURLClass.php line 392 | is_product_group |
0.2272 | 0.2275 | 0.00028 |
SELECT wa.* FROM WebArticle as wa
LEFT JOIN WebContent as wc ON wa.pageno = wc.pageno
WHERE ptitle='News' AND wa.visible='Y' Order By articledate Desc LIMIT 0, 4
| /var/www/vhosts/devactiverehab.oglsoftware.co.uk/public/include/content.php line 360 | queryArticleHome |