| 0.0001 |
SELECT *
FROM `corporate`
WHERE `id` = 1
|
| 0.0491 |
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.0013 |
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.0001 |
SELECT *
FROM `corporate_theme`
WHERE `slug` = 'peaky-blinders-theme'
|
| 0.0002 |
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` = '2'
|
| 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` = '2'
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parentid` =0
ORDER BY `sortorder` ASC
|
| 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` = '2701'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2701'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2701'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '118'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2701'
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` = '2701'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2701'
|
| 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` = '964'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '964'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '964'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '112'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '964'
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` = '964'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0003 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '964'
|
| 0.0032 |
SELECT a.*, r.reasonstobook
FROM `warbleen_crm`.`act` `a`
LEFT JOIN `warbleen_crm`.`act_reasonstobook` `r` ON `r`.`act_id` = `a`.`id`
WHERE `id` = '1036'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '1036'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '1036'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '120'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '1036'
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` = '1036'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '1036'
|
| 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` = '1630'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '1630'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '1630'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '50'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '1630'
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` = '1630'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0003 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '1630'
|
| 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` = '2760'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2760'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2760'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '59'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2760'
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` = '2760'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2760'
|
| 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` = '2389'
|
| 0.0005 |
SELECT *
FROM `warbleen_crm`.`act_profilephoto`
WHERE `act_id` = '2389'
|
| 0.0008 |
SELECT *
FROM `warbleen_crm`.`act_covervideo`
WHERE `act_id` = '2389'
|
| 0.0004 |
SELECT *
FROM `warbleen_crm`.`county`
WHERE `id` = '112'
|
| 0.0006 |
SELECT *
FROM `warbleen_crm`.`act_audio`
WHERE `act_id` = '2389'
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` = '2389'
ORDER BY `price` ASC
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `warbleen_front`.`homepage_acts` `p`
WHERE `p`.`actid` = '2389'
|
| 0.0021 |
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
|
