| 0.0379 |
SELECT *
FROM `category`
WHERE `category_url` = 'singapore'
|
| 0.0378 |
SELECT *
FROM `category`
WHERE `category_url` = 'singapore'
|
| 0.0378 |
SELECT *
FROM `category`
WHERE `category_url` = 'fashion'
|
| 0.1125 |
SELECT *
FROM `category`
WHERE `parent_id` = 0
|
| 0.0380 |
SELECT *
FROM `category`
WHERE `parent_id` = '1'
|
| 0.0381 |
SELECT *
FROM `category`
WHERE `parent_id` = '2'
|
| 0.0381 |
SELECT *
FROM `category`
WHERE `parent_id` = '5'
|
| 0.0380 |
SELECT *
FROM `category`
WHERE `parent_id` = '7'
|
| 0.0377 |
SELECT *
FROM `category`
WHERE `parent_id` = '8'
|
| 0.0381 |
SELECT *
FROM `category`
WHERE `parent_id` = '11'
|
| 0.0378 |
SELECT *
FROM `category`
WHERE `parent_id` = '32'
|
| 0.0378 |
SELECT *
FROM `category`
WHERE `parent_id` = '166'
|
| 0.0377 |
SELECT *
FROM `category`
WHERE `parent_id` = '182'
|
| 0.0378 |
SELECT *
FROM `category`
WHERE `parent_id` = '188'
|
| 0.0379 |
SELECT *
FROM `category`
WHERE `parent_id` = '223'
|
| 0.0381 |
SELECT *
FROM `category`
WHERE `parent_id` = '229'
|
| 0.0376 |
SELECT *
FROM `category`
WHERE `parent_id` = '235'
|
| 0.0375 |
SELECT *
FROM `category`
WHERE `parent_id` = '263'
|
| 0.0377 |
SELECT *
FROM `category`
WHERE `parent_id` = '268'
|
| 0.0380 |
SELECT *
FROM `category`
WHERE `parent_id` = '5'
|
| 0.2736 |
SELECT `promotions`.*, `brand`.`brand_name`, `category`.`name` as `category_name`, `category`.`category_url`
FROM `promotions`
LEFT JOIN `brand_stores` ON `brand_stores`.`id` = `promotions`.`promotion_stores`
LEFT JOIN `brand` ON `brand`.`id` = `brand_stores`.`brand_id`
LEFT JOIN `promo_categories` ON `promo_categories`.`promotion_id` = `promotions`.`id`
LEFT JOIN `category` ON `category`.`id` = `promo_categories`.`category_id`
WHERE `promotions`.`types` = 'Promotion'
AND `promotions`.`status` = 'Published'
AND `promo_categories`.`category_id` IN('16', '17', '249', '278', '279', '5')
AND `promotions`.`suspend` = 'N'
AND `promotions`.`ban` = 'N'
OR `promotions`.`city` = 'Global'
AND `promotions`.`types` = 'Promotion'
AND `promo_categories`.`category_id` IN('16', '17', '249', '278', '279', '5', '5')
AND `promotions`.`status` = 'Published'
AND `promotions`.`suspend` = 'N'
AND `promotions`.`ban` = 'N'
GROUP BY `promotions`.`id`
ORDER BY `promotions`.`promotion_end_date` DESC, `promotions`.`promotion_end_date` DESC, `promotions`.`auto_created` ASC
LIMIT 10, 12
|
| 0.0380 |
SELECT *
FROM `category`
WHERE `parent_id` = '5'
|
| 0.2054 |
SELECT COUNT(promotions.id) AS promotion_count
FROM `promotions`
LEFT JOIN `brand_stores` ON `brand_stores`.`id` = `promotions`.`promotion_stores`
LEFT JOIN `brand` ON `brand`.`id` = `brand_stores`.`brand_id`
LEFT JOIN `promo_categories` ON `promo_categories`.`promotion_id` = `promotions`.`id`
LEFT JOIN `category` ON `category`.`id` = `promo_categories`.`category_id`
WHERE `promotions`.`types` = 'Promotion'
AND `promotions`.`status` = 'Published'
AND `promo_categories`.`category_id` IN('16', '17', '249', '278', '279', '5')
AND `promotions`.`suspend` = 'N'
AND `promotions`.`ban` = 'N'
OR `promotions`.`city` = 'Global'
AND `promotions`.`types` = 'Promotion'
AND `promo_categories`.`category_id` IN('16', '17', '249', '278', '279', '5', '5')
AND `promotions`.`status` = 'Published'
AND `promotions`.`suspend` = 'N'
AND `promotions`.`ban` = 'N'
GROUP BY `brand`.`brand_name`, `promotions`.`id`
ORDER BY `promotions`.`promotion_end_date` DESC, `promotions`.`promotion_end_date` DESC, `promotions`.`auto_created` ASC
|
| 0.0813 |
SELECT *
FROM `currency`
GROUP BY `currency_code`
|
| 0.0764 |
SELECT `category`.*, `cat`.`name` as `parent_category_name`
FROM `category`
LEFT JOIN `category` `cat` ON `cat`.`id` = `category`.`parent_id`
GROUP BY `category`.`id`
ORDER BY `name`
|
| 0.0375 |
SELECT *
FROM `countries`
WHERE `name` = 'United Kingdom'
|
| 0.0377 |
SELECT *
FROM `meta_data`
|
| 0.1047 |
SELECT *
FROM `currency`
GROUP BY `currency_code`
|
| 0.0379 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0374 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0375 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0375 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0374 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0375 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0374 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0377 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0377 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0380 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0376 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0376 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0381 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0377 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0378 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0376 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0374 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'EUR'
|
| 0.0379 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
| 0.0380 |
SELECT `currency`.`rate`
FROM `currency`
WHERE `currency_code` = 'EUR'
AND `base` = 'GBP'
|
Mens
Womens
Baby
Boys
Girls
