0.0008 |
SELECT * FROM `corporate` WHERE `id` = 1
|
0.0704 |
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.0016 |
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.0005 |
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.0005 |
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.0047 |
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.0006 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2701'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2701'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '118'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '2701' AND `s3_status` = 1 ORDER BY `order` ASC LIMIT 5
|
0.0001 |
SELECT p.price FROM `warbleen_crm`.`act_price` `p` WHERE `p`.`act_id` = '2701' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2701'
|
0.0041 |
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.0007 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '964'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '112'
|
0.0007 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '964' 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` = '964' ORDER BY `price` ASC LIMIT 1
|
0.0004 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '964'
|
0.0039 |
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.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '1036'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '120'
|
0.0002 |
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.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '1036'
|
0.0038 |
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.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '1630'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '50'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '1630' 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` = '1630' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '1630'
|
0.0039 |
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.0006 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2760'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2760'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '59'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '2760' 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` = '2760' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2760'
|
0.0002 |
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.0003 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2389'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2389'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '112'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '2389' AND `s3_status` = 1 ORDER BY `order` ASC LIMIT 5
|
0.0001 |
SELECT p.price FROM `warbleen_crm`.`act_price` `p` WHERE `p`.`act_id` = '2389' ORDER BY `price` ASC LIMIT 1
|
0.0001 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2389'
|
0.0003 |
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.0003 |
SELECT `id`, `region` FROM `warbleen_crm`.`region` ORDER BY `region` asc
|
0.0002 |
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
|