| 0.0004 |
SELECT *
FROM (`global_config_variable`)
WHERE gcv_name='enable_global_redirection'
|
| 0.0005 |
SELECT *
FROM (`config_data`)
|
| 0.0007 |
SELECT `CompanyID`, `CompanyName`, `CompanyWebsite`, `ContactPerson`, `CompnayLogo`, `is_logo_from_csn`, `seo_pro`, `primary_cat`, `short_desc`, `long_desc`, `ShortDescriptionHTML`, `CompanyAddress`, `CompanyPhone`, `CompanyEmail`, `CompanyMobile`, `primary_cat`, `primary_region`, `primary_country`, `show_company_img_as`, `howto_status`, `howto_img`, `howto_img_link`, `direct_link`, `howto_seoprofile`, `howto`, `voucher_code_type`, `voucher_sale_type`, `notes`, `CompanyWebsiteURL`, `last_voucher_sequence_update`, `show_default_company_note`, `product_url`, `code_type`, `CompanyMobile`, `CompanyEmail`, `CompanyWebsite`, `facebook_url`, `whats_app_number`, `help_center`, `last_updated_date`
FROM (`company`)
WHERE `ContactPerson` = 'nextdirect'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`company_csv_data`)
WHERE CompanyID=248 and link_type=1 and is_online=1 and is_active=1
|
| 0.0010 |
SELECT company.CompnayLogo, company.CompanyName, company.is_logo_from_csn, company.ContactPerson, product.*
FROM (`product`)
INNER JOIN `similar_company_voucher_records` ON `similar_company_voucher_records`.`voucher_id` = `product`.`ProductID`
INNER JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
WHERE similar_company_voucher_records.company_id= 248 AND similar_company_voucher_records.company_id = 248 AND similar_company_voucher_records.company_type = 1 AND ProductEndDate >= NOW() AND ProductStartDate <= NOW() AND product.is_deleted != 1 AND product.link_type = 1
LIMIT 5
|
| 0.0004 |
SELECT `CountryID`
FROM (`countries`)
WHERE `CountryCode` = ''
|
| 0.0003 |
SELECT *
FROM (`seoprofiles`)
WHERE `id` = '15'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`seo_socialmedia`)
WHERE `id` = 1
|
| 0.0003 |
SELECT `id`, `voucher_type`
FROM (`voucher_type`)
|
| 0.0003 |
SELECT `discount_type_id`, `discount_type`
FROM (`discount_type`)
|
| 0.0005 |
SELECT *
FROM (`category`)
WHERE `IsActive` = 1
AND `status` = 1
|
| 0.0006 |
SELECT *
FROM (`countries`)
|
| 0.0006 |
SELECT count(id) as total_reviews
FROM (`company_rating`)
WHERE company_id = 248
|
| 0.0004 |
SELECT count(vote) as upVote
FROM (`company_rating`)
WHERE company_id = 248 AND vote = 1
|
| 0.0004 |
SELECT `CountryID`
FROM (`countries`)
WHERE `CountryCode` = ''
|
| 0.0003 |
SELECT *
FROM (`global_config_variable`)
WHERE gcv_name='companyXMLPurge'
|
| 0.0003 |
SELECT `number_of_days`
FROM (`number_of_days_last_downloaded`)
LIMIT 1
|
| 0.0035 |
SELECT DISTINCT `product`.`ProductName` as `ProductNameForTitle`, (CASE WHEN product.ProductEndDate >= NOW() THEN "NO" ELSE "YES" END) `Expired`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
LEFT OUTER JOIN `productcategory` ON `product`.`ProductID` = `productcategory`.`ProductID`
LEFT OUTER JOIN `category` ON `productcategory`.`CategoryID` = `category`.`CategoryID`
WHERE company.CompanyID = 248 AND product.ProductEndDate < CURDATE() AND product.turn_off = 1 And product.turn_off=1
ORDER BY `product`.`coupon_type` = 7, `product`.`ProductEndDate` desc
LIMIT 5
|
| 0.0004 |
SELECT *
FROM (`seoprofiles`)
WHERE `id` = '15'
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`seo_socialmedia`)
WHERE `id` = 1
|
| 0.0003 |
SELECT *
FROM (`companydescriptiontemplates`)
WHERE `ID` = '2'
|
| 0.0005 |
SELECT *
FROM (`company_icon`)
INNER JOIN `company_more_details` ON `company_more_details`.`icon_id` = `company_icon`.`icon_id`
WHERE `company_more_details`.`company_id` = '248'
LIMIT 50
|
| 0.0005 |
SELECT category.CategoryName, seoprofile.display_url, ProductEndDate
FROM (`product`)
INNER JOIN `productcategory` ON `productcategory`.`ProductID` = `product`.`ProductID`
INNER JOIN `category` ON `category`.`CategoryID` = `productcategory`.`CategoryID`
INNER JOIN `seoprofile` ON `seoprofile`.`cate_id` = `category`.`CategoryID`
WHERE show_on_company_page = 1 AND product.ProductEndDate >= NOW() AND productStartDate <= NOW() and product.is_deleted = 0 AND product.CompanyID = 248
LIMIT 20
|
| 0.0003 |
SELECT *
FROM (`share_voucher_setting`)
WHERE status = 1
|
| 0.0004 |
SELECT `ProductName`
FROM (`product`)
WHERE CompanyID = '248' and product.ProductEndDate >= NOW() AND product.is_deleted = 0 and product.status not in(8,10,11)
ORDER BY `EntryDate` DESC
LIMIT 1
|
| 0.0004 |
SELECT `ProductName`, `is_exclusive`
FROM (`product`)
WHERE CompanyID = '248' and product.ProductEndDate >= NOW() AND product.is_deleted = 0
ORDER BY `is_exclusive` DESC, `ProductPromotionCode` DESC, `last_xdays_clicks` DESC
LIMIT 2
|
| 0.0003 |
SELECT `logo_name`, `alt_text`
FROM (`payment_methods`)
INNER JOIN `company_payment_method` ON `payment_methods`.`payment_method_id` = `company_payment_method`.`payment_method_id`
WHERE `company_payment_method`.`company_id` = '248'
|
| 0.0005 |
SELECT `ProductName`, `ProductPromotionCode`, `ProductID`, `tested_date`, `tested`
FROM (`product`)
WHERE `CompanyID` = '248'
AND `ProductEndDate` >= CURDATE() AND ProductStartDate <= CURDATE() AND product.status != 2 AND ProductPromotionCode != '' AND tested = 1 AND tested_date != '0000-00-00 00:00:00' AND passbook_enabled != 3
AND `turn_off` = 1
AND `is_deleted` != 1
ORDER BY `last_xdays_clicks` desc, `Position` asc, `EntryDate` desc
LIMIT 20
|
| 0.0005 |
SELECT `ProductName`, `ProductPromotionCode`, `ProductID`, `tested_date`, `tested`, `ProductEndDate`, `promotion`, `voucher_code_type`, `ProductStartDate`, `voucher_tracking_type`, `Position`
FROM (`product`)
INNER JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
WHERE `product`.`CompanyID` = '248'
AND `ProductEndDate` >= CURDATE() AND ProductStartDate <= CURDATE() AND passbook_enabled != 3
AND `turn_off` = 1
AND `is_deleted` != 1
ORDER BY `Position` = 0 asc, `Position` asc, `last_xdays_clicks` desc, `EntryDate` desc
LIMIT 20
|
| 0.0004 |
SELECT company.CompanyName, company.ContactPerson
FROM (`company`)
WHERE company.primary_cat != 1342 AND company.companylink_status = 'On' AND company.tier < 11
ORDER BY `company`.`tier` ASC
LIMIT 50
|
| 0.0003 |
SELECT `CategoryID`, `CategoryName`, `parent`
FROM (`category`)
WHERE `CategoryID` = '1342'
LIMIT 1
|
| 0.0014 |
SELECT distinct company.CompanyID,company.ContactPerson,company.CompnayLogo, company.is_logo_from_csn,company.CompanyName,company.tier, seoprofiles.alt_text_img_voucher, company.seo_pro,total_voucher_clicks FROM company
LEFT join seoprofiles on seoprofiles.id = company.seo_pro
WHERE company.CompanyID!=248 AND company.companylink_status = 'On' AND company.companylink_status = 'On' AND (company.primary_cat = 1342 or company.primary_cat = 0) order by company.primary_cat <> '1342' , company.primary_cat <> '0' ,company.primary_country <> '66' , company.tier limit 5
|
| 0.0015 |
SELECT DISTINCT company.CompanyID, company.CompanyName, company.ContactPerson, SUM( product.last_xdays_clicks ) AS 'last_xdays_clicks' FROM (`product`) INNER JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID` WHERE company.primary_cat= 1342 AND company.CompanyID != 248 AND company.companylink_status = 'On' AND product.ProductEndDate >= CURDATE() and DATE(product.EntryDate) >= '2018-10-01' AND DATE(product.EntryDate) <= '2019-03-31' AND last_xdays_clicks > 0 GROUP BY `product`.`CompanyID` ORDER BY `last_xdays_clicks` DESC LIMIT 10
|
| 0.0015 |
SELECT DISTINCT `category`.`CategoryID`, `CategoryName`, `display_url`
FROM (`category`)
INNER JOIN `seoprofile` ON `category`.`CategoryID` = `seoprofile`.`cate_id`
INNER JOIN `productcategory` ON `category`.`CategoryID` = `productcategory`.`CategoryID`
WHERE (parent = 1342)
AND `IsActive` = '1'
AND `category`.`turn_on` = '1'
AND `category_profile` = 'Category'
AND `display_url` != '' AND display_url != 'promo/'
AND `CategoryName` != ''
ORDER BY `last_xdays_click` desc
|
| 0.0020 |
SELECT DISTINCT company.CompanyID, company.CompanyName, company.ContactPerson, SUM( product.last_xdays_clicks ) AS 'last_xdays_clicks' FROM (`product`) INNER JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID` WHERE company.primary_cat= 1342 AND company.CompanyID != 248 AND company.companylink_status = 'On' AND product.ProductEndDate >= CURDATE() GROUP BY `product`.`CompanyID` ORDER BY `last_xdays_clicks` DESC LIMIT 10
|
| 0.0004 |
SELECT *
FROM (`company_notes`)
WHERE company_id = 248
ORDER BY `position_order` asc
|
| 0.0004 |
SELECT *
FROM (`global_config_variable`)
WHERE gcv_name='amp_pages'
|
| 0.0004 |
SELECT `promotion_banner`.*, `company`.`ContactPerson`, `product`.`ProductPromotionCode`
FROM (`promotion_banner`)
LEFT JOIN `product` ON `product`.`ProductID` = `promotion_banner`.`linked_voucher`
LEFT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
WHERE `promotion_banner`.`status` = 1
AND `promotion_banner`.`link` != ''
AND `promotion_banner`.`expire_date` >= CURDATE()
AND `promotion_banner`.`placement` LIKE '%1%'
LIMIT 1
|
| 0.0003 |
SELECT id FROM region WHERE FIND_IN_SET(66,CountryIDs)
|
| 0.0020 |
SELECT distinct company.CompanyID,company.ContactPerson,company.CompnayLogo, company.is_logo_from_csn, company.CompanyName,company.tier, seoprofiles.alt_text_img_voucher, company.seo_pro,total_voucher_clicks FROM company
INNER Join companycategory ON companycategory.CompanyID = company.CompanyID
INNER join category on companycategory.CategoryID= category.CategoryID
LEFT join seoprofiles on seoprofiles.id = company.seo_pro
WHERE (primary_country=66 AND (company.primary_cat=1342 OR companycategory.CategoryID = 1342 OR category.parent = 1342)) AND company.CompanyID!=248 AND company.companylink_status = 'On' AND company.companylink_status = 'On' order by tier,company.total_voucher_clicks desc
|
| 0.0013 |
SELECT distinct company.CompanyID,company.ContactPerson,company.CompnayLogo, company.is_logo_from_csn, company.CompanyName,company.tier, seoprofiles.alt_text_img_voucher,company.seo_pro,total_voucher_clicks FROM company
inner join companycategory on companycategory.CompanyID = company.CompanyID
inner join category on companycategory.CategoryID= category.CategoryID
LEFT join seoprofiles on seoprofiles.id = company.seo_pro
WHERE FIND_IN_SET(8,company.region) AND (company.primary_cat=1342 OR companycategory.CategoryID = 1342 OR category.parent = 1342) AND company.CompanyID!=248 AND company.companylink_status = 'On' AND (company.tier != '' AND company.tier IS NOT NULL AND company.tier != 0)AND company.companylink_status = 'On' order by tier,company.total_voucher_clicks desc
|
| 0.0013 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 228 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0007 |
select productid,(sum(CASE WHEN register =1 THEN 1 ELSE 0 END )-SUM(CASE WHEN register =0 THEN 1 ELSE 0 END )) COUNT FROM
voucherrating where productid='957720' group by productid
|
| 0.0003 |
select * from top_rating
|
| 0.0010 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 266 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0010 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 224 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0010 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 232 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0006 |
select productid,(sum(CASE WHEN register =1 THEN 1 ELSE 0 END )-SUM(CASE WHEN register =0 THEN 1 ELSE 0 END )) COUNT FROM
voucherrating where productid='957526' group by productid
|
| 0.0003 |
select * from top_rating
|
| 0.0010 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 330 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0007 |
select productid,(sum(CASE WHEN register =1 THEN 1 ELSE 0 END )-SUM(CASE WHEN register =0 THEN 1 ELSE 0 END )) COUNT FROM
voucherrating where productid='957763' group by productid
|
| 0.0003 |
select * from top_rating
|
| 0.0010 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 221 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0009 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 261 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0006 |
select productid,(sum(CASE WHEN register =1 THEN 1 ELSE 0 END )-SUM(CASE WHEN register =0 THEN 1 ELSE 0 END )) COUNT FROM
voucherrating where productid='957742' group by productid
|
| 0.0003 |
select * from top_rating
|
| 0.0009 |
SELECT DISTINCT CONCAT(product.ProductName, " at ", company.CompanyName) `ProductNameForTitle`, `company`.*, `product`.*, `company`.`CompanyID`, `company`.`CountryID` as CCID, `company`.`LanguageID` as LID, `seoprofiles`.`alt_text_img_voucher`
FROM (`product`)
RIGHT JOIN `company` ON `company`.`CompanyID` = `product`.`CompanyID`
RIGHT JOIN `seoprofiles` ON `company`.`seo_pro` = `seoprofiles`.`id`
WHERE company.CompanyID = 249 AND product.ProductEndDate >= NOW() AND product.ProductStartDate <= NOW() AND product.is_deleted != 1 and product.status not in(8,10,11)
ORDER BY `product`.`EntryDate` desc, `product`.`GetCodeOpenSite` desc, `product`.`OnlineSales`
LIMIT 1
|
| 0.0006 |
select productid,(sum(CASE WHEN register =1 THEN 1 ELSE 0 END )-SUM(CASE WHEN register =0 THEN 1 ELSE 0 END )) COUNT FROM
voucherrating where productid='957750' group by productid
|
| 0.0003 |
select * from top_rating
|
| 0.0005 |
SELECT *
FROM (`upcoming_holidays`)
WHERE (MONTH(ADDDATE(CONCAT('2019','-',start_date), INTERVAL -30 DAY)) < MONTH('2019-04-19') or (MONTH(ADDDATE(CONCAT('2019','-',start_date), INTERVAL -30 DAY)) = MONTH('2019-04-19') AND DAY(ADDDATE(CONCAT('2019','-',start_date), INTERVAL -30 DAY)) < DAY('2019-04-19'))) AND (MONTH(ADDDATE(CONCAT('2019','-',end_date), INTERVAL +15 DAY)) > MONTH('2019-04-19') or (MONTH(ADDDATE(CONCAT('2019','-',end_date), INTERVAL +15 DAY)) = MONTH('2019-04-19') AND DAY(ADDDATE(CONCAT('2019','-',end_date), INTERVAL +15 DAY)) < DAY('2019-04-19')) AND MONTH(ADDDATE(end_date, INTERVAL +15 DAY)) > MONTH(CURDATE()) AND DAY(ADDDATE(end_date, INTERVAL +15 DAY)) > DAY(CURDATE()) )
AND `is_deleted` = 0
AND `status` = 1
AND `status` = 1
ORDER BY `start_date`
LIMIT 5
|
