SELECT (`site`.`partner_id`) AS `partner_id`,
(`site`.`title`) AS `title`,
(`site`.`hostname`) AS `hostname`,
(`site`.`theme`) AS `theme`,
(`site`.`favicon`) AS `favicon`,
(`site`.`address`) AS `address`,
(`site`.`postcode`) AS `postcode`,
(`site`.`vat_number`) AS `vat_number`,
(`site`.`imap_server`) AS `imap_server`,
(`site`.`imap_username`) AS `imap_username`,
(`site`.`imap_password`) AS `imap_password`,
(`site`.`created`) AS `created`,
(`site`.`updated`) AS `updated`,
(`partner`.`id`) AS `id`,
(`partner`.`name`) AS `name`,
(`partner`.`email`) AS `email`,
(`partner`.`telephone`) AS `telephone`,
(`partner`.`dx`) AS `dx`,
(`partner`.`referrers`) AS `referrers`,
(`partner`.`vat_registered`) AS `vat_registered`,
(`partner`.`api_key`) AS `api_key`,
(`partner`.`content`) AS `content`,
(`partner`.`image`) AS `image`,
(`partner`.`agreement`) AS `agreement`,
(`partner`.`partner_rate`) AS `partner_rate`,
(`partner`.`admin_rate`) AS `admin_rate`,
(`partner`.`xero_id`) AS `xero_id`,
(`partner`.`internal`) AS `internal`,
(`partner`.`static`) AS `static`,
(`partner`.`publish`) AS `publish`,
(`partner`.`discard`) AS `discard`
FROM `site`
INNER JOIN `partner` ON `partner`.`id` = `site`.`partner_id`
Command completed in 0.00031399726867676 seconds - 2 row(s) affected.
SELECT (`label`.`id`) AS `id`,
(`label`.`name`) AS `name`,
(`label`.`path`) AS `path`,
(`label`.`source`) AS `source`,
(`label`.`content`) AS `content`,
(`label`.`block`) AS `block`,
(`label`.`discard`) AS `discard`
FROM `label`
WHERE `label`.`discard` IS FALSE
AND (`label`.`path` = ''
OR '/barristers/229-paul-newman' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.010365009307861 seconds - 624 row(s) affected.
SELECT (`barrister`.`id`) AS `id`,
(`barrister`.`chambers_id`) AS `chambers_id`,
(`barrister`.`online_id`) AS `online_id`,
(`barrister`.`c365_id`) AS `c365_id`,
(`barrister`.`first_name`) AS `first_name`,
(`barrister`.`last_name`) AS `last_name`,
(`barrister`.`summary`) AS `summary`,
(`barrister`.`content`) AS `content`,
(`barrister`.`email`) AS `email`,
(`barrister`.`telephone`) AS `telephone`,
(`barrister`.`admitted`) AS `admitted`,
(`barrister`.`called_to_bar`) AS `called_to_bar`,
(`barrister`.`took_silk`) AS `took_silk`,
(`barrister`.`cc_name`) AS `cc_name`,
(`barrister`.`cc_email`) AS `cc_email`,
(`barrister`.`image`) AS `image`,
(`barrister`.`vat_registered`) AS `vat_registered`,
(`barrister`.`vat_number`) AS `vat_number`,
(`barrister`.`handles_complaints`) AS `handles_complaints`,
(`barrister`.`conducts_litigation`) AS `conducts_litigation`,
(`barrister`.`xero_id`) AS `xero_id`,
(`barrister`.`confirm`) AS `confirm`,
(`barrister`.`indexable`) AS `indexable`,
(`barrister`.`publish`) AS `publish`,
(`barrister`.`discard`) AS `discard`,
(`barrister`.`created`) AS `created`,
(`barrister`.`updated`) AS `updated`
FROM `barrister`
WHERE `barrister`.`id` = '229'
AND `barrister`.`discard` IS FALSE
AND `barrister`.`publish` IS TRUE
Command completed in 0.00066614151000977 seconds - 1 row(s) affected.
SELECT (`chambers`.`id`) AS `id`,
(`chambers`.`name`) AS `name`,
(`chambers`.`email`) AS `email`,
(`chambers`.`line_1`) AS `line_1`,
(`chambers`.`line_2`) AS `line_2`,
(`chambers`.`line_3`) AS `line_3`,
(`chambers`.`city`) AS `city`,
(`chambers`.`postcode`) AS `postcode`,
(`chambers`.`telephone`) AS `telephone`,
(`chambers`.`fax`) AS `fax`,
(`chambers`.`dx`) AS `dx`,
(`chambers`.`discard`) AS `discard`,
(`chambers`.`created`) AS `created`,
(`chambers`.`updated`) AS `updated`
FROM `chambers`
WHERE `chambers`.`discard` IS FALSE
AND `chambers`.`id` IN (3)
ORDER BY `chambers`.`name` ASC, `chambers`.`id` ASC
Command completed in 0.00058197975158691 seconds - 1 row(s) affected.
SELECT (`barrister_region`.`barrister_id`) AS `barrister_id`,
(`barrister_region`.`region_id`) AS `region_id`
FROM `barrister_region`
WHERE `barrister_region`.`barrister_id` IN (229)
Command completed in 0.0026769638061523 seconds - 5 row(s) affected.
SELECT (`region`.`id`) AS `id`,
(`region`.`ordinal`) AS `ordinal`,
(`region`.`name`) AS `name`,
(`region`.`discard`) AS `discard`,
(`region`.`updated`) AS `updated`
FROM `region`
WHERE `region`.`discard` IS FALSE
AND `region`.`id` IN (2, 4, 5, 6, 7)
ORDER BY `region`.`ordinal` ASC, `region`.`name` ASC, `region`.`id` ASC
Command completed in 0.0043351650238037 seconds - 5 row(s) affected.
SELECT (`area_of_law`.`id`) AS `id`,
(`area_of_law`.`parent`) AS `parent`,
(`barrister_area_of_law`.`ordinal`) AS `ordinal`,
(`area_of_law`.`online_id`) AS `online_id`,
(`area_of_law`.`c365_id`) AS `c365_id`,
(`area_of_law`.`name`) AS `name`,
(`area_of_law`.`color`) AS `color`,
(`area_of_law`.`admin_colour`) AS `admin_colour`,
(`area_of_law`.`publish`) AS `publish`,
(`area_of_law`.`discard`) AS `discard`,
(`area_of_law`.`updated`) AS `updated`
FROM `area_of_law`
INNER JOIN `barrister_area_of_law` ON `barrister_area_of_law`.`area_of_law_id` = `area_of_law`.`id` AND `barrister_area_of_law`.`barrister_id` = 229
WHERE `area_of_law`.`discard` IS FALSE
AND `area_of_law`.`publish` IS TRUE
AND `area_of_law`.`id` IN (
SELECT `area_of_law_id`
FROM `barrister_area_of_law`
WHERE `barrister_area_of_law`.`barrister_id` = 229)
ORDER BY `barrister_area_of_law`.`ordinal`, `area_of_law`.`ordinal` ASC, `area_of_law`.`id` ASC
Command completed in 0.0017049312591553 seconds - 7 row(s) affected.
SELECT (`testimonial`.`id`) AS `id`,
(`testimonial`.`barrister_id`) AS `barrister_id`,
(`testimonial`.`name`) AS `name`,
(`testimonial`.`title`) AS `title`,
(`testimonial`.`rating`) AS `rating`,
(`testimonial`.`content`) AS `content`,
(`testimonial`.`publish`) AS `publish`,
(`testimonial`.`discard`) AS `discard`,
(`testimonial`.`updated`) AS `updated`
FROM `testimonial`
WHERE `testimonial`.`discard` IS FALSE
AND `testimonial`.`publish` IS TRUE
AND (`barrister_id` = 229 OR `barrister_id` IS NULL)
ORDER BY `testimonial`.`barrister_id` DESC, RAND()
LIMIT 10
Command completed in 0.0017039775848389 seconds - 3 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`site_id`) AS `site_id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`content`) AS `content`,
(`page`.`hero`) AS `hero`,
(`page`.`banner_id`) AS `banner_id`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`static`) AS `static`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
AND `page`.`site_id` = 1
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.00030684471130371 seconds - 42 row(s) affected.
