0.0025 |
SELECT * FROM `corporate` WHERE `id` = 1
|
0.0668 |
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.0069 |
SELECT * FROM `corporate_theme` WHERE `slug` = 'winter-wonderland-theme'
|
0.0008 |
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.0008 |
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.0045 |
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.0006 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2435'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2435'
|
0.0005 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '122'
|
0.0002 |
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.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2435'
|
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` = '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.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '120'
|
0.0006 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '893' 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` = '893' ORDER BY `price` ASC LIMIT 1
|
0.0004 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '893'
|
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` = '1103'
|
0.0006 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '1103'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '1103'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '68'
|
0.0007 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '1103' AND `s3_status` = 1 ORDER BY `order` ASC LIMIT 5
|
0.0002 |
SELECT p.price FROM `warbleen_crm`.`act_price` `p` WHERE `p`.`act_id` = '1103' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '1103'
|
0.0003 |
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.0002 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2159'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2159'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '66'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '2159' AND `s3_status` = 1 ORDER BY `order` ASC LIMIT 5
|
0.0002 |
SELECT p.price FROM `warbleen_crm`.`act_price` `p` WHERE `p`.`act_id` = '2159' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2159'
|
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` = '1958'
|
0.0005 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '1958'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '1958'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '112'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '1958' 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` = '1958' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '1958'
|
0.0054 |
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.0005 |
SELECT * FROM `warbleen_crm`.`act_profilephoto` WHERE `act_id` = '2001'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`act_covervideo` WHERE `act_id` = '2001'
|
0.0003 |
SELECT * FROM `warbleen_crm`.`county` WHERE `id` = '112'
|
0.0002 |
SELECT * FROM `warbleen_crm`.`act_audio` WHERE `act_id` = '2001' 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` = '2001' ORDER BY `price` ASC LIMIT 1
|
0.0002 |
SELECT * FROM `warbleen_front`.`homepage_acts` `p` WHERE `p`.`actid` = '2001'
|
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
|