| 0.0002 |
SELECT *
FROM `corporate`
WHERE `id` = 1
|
| 0.0485 |
SELECT warbleen_crm.act.*, warbleen_crm.act_profilephoto.path
FROM `warbleen_crm`.`act`
JOIN `warbleen_crm`.`act_profilephoto` ON `warbleen_crm`.`act_profilephoto`.`act_id` = `warbleen_crm`.`act`.`id`
|
| 0.0019 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '1429'
|
| 0.0002 |
SELECT *
FROM `corporate_theme`
WHERE `slug` = 'winter-wonderland-theme'
|
| 0.0003 |
SELECT *
FROM `corporate_theme_trending`
JOIN `warbleen_crm`.`act` ON `warbleen_crm`.`act`.`id` = `corporate_theme_trending`.`act_id`
LEFT JOIN `warbleen_crm`.`act_coverphoto` ON `warbleen_crm`.`act_coverphoto`.`act_id` = `corporate_theme_trending`.`act_id`
WHERE `theme_id` = '3'
|
| 0.0003 |
SELECT *
FROM `corporate_theme_other`
JOIN `warbleen_crm`.`act` ON `warbleen_crm`.`act`.`id` = `corporate_theme_other`.`act_id`
LEFT JOIN `warbleen_crm`.`act_coverphoto` ON `warbleen_crm`.`act_coverphoto`.`act_id` = `corporate_theme_other`.`act_id`
WHERE `theme_id` = '3'
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parentid` =0
ORDER BY `sortorder` ASC
|
| 0.0031 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '2435'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2435'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2435'
|
| 0.0003 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '122'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2435'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0009 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '2435'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0005 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2435'
|
| 0.0029 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '893'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '893'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '893'
|
| 0.0003 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '120'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '893'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0008 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '893'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '893'
|
| 0.0030 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '1103'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '1103'
|
| 0.0007 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '1103'
|
| 0.0003 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '68'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '1103'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0010 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '1103'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '1103'
|
| 0.0030 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '2159'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2159'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2159'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '66'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2159'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0008 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '2159'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0003 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2159'
|
| 0.0028 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '1958'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '1958'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '1958'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '112'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '1958'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0007 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '1958'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '1958'
|
| 0.0029 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '2001'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2001'
|
| 0.0007 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2001'
|
| 0.0003 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '112'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2001'
AND `s3_status` = 1
ORDER BY `order` ASC
LIMIT 5
|
| 0.0009 |
SELECT p.price
FROM `warbleen_crm`.`act_price` `p`
WHERE `p`.`act_id` = '2001'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2001'
|
| 0.0020 |
SELECT *
FROM `warbleen_crm`.`region` `r`
JOIN `warbleen_crm`.`county` `c` ON `r`.`id` = `c`.`region_id`
WHERE `c`.`status` = 1
ORDER BY `c`.`county` ASC
|
| 0.0005 |
SELECT `id`, `region`
FROM `warbleen_crm`.`region`
ORDER BY `region` asc
|
| 0.0007 |
SELECT warbleen_crm.act.name AS act_name, warbleen_crm.act.slug, warbleen_crm.act_profilephoto.path, warbleen_crm.feedback.*
FROM `warbleen_crm`.`feedback`
JOIN `warbleen_crm`.`act` ON `warbleen_crm`.`act`.`id` = `warbleen_crm`.`feedback`.`act_id`
JOIN `warbleen_crm`.`act_profilephoto` ON `warbleen_crm`.`act_profilephoto`.`act_id` = `warbleen_crm`.`act`.`id`
WHERE `approved` = 1
ORDER BY `warbleen_crm`.`feedback`.`id` DESC
LIMIT 1
|
