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` = '397'
AND `barrister`.`discard` IS FALSE
AND `barrister`.`publish` IS TRUE
Command completed in 0.0004270076751709 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 (11)
ORDER BY `chambers`.`name` ASC, `chambers`.`id` ASC
Command completed in 0.00026297569274902 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 (397)
Command completed in 0.0002129077911377 seconds - 8 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 (1, 2, 3, 4, 5, 8, 9, 10)
ORDER BY `region`.`ordinal` ASC, `region`.`name` ASC, `region`.`id` ASC
Command completed in 0.00024890899658203 seconds - 7 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` = 397
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` = 397)
ORDER BY `barrister_area_of_law`.`ordinal`, `area_of_law`.`ordinal` ASC, `area_of_law`.`id` ASC
Command completed in 0.00040411949157715 seconds - 5 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` = 397 OR `barrister_id` IS NULL)
ORDER BY `testimonial`.`barrister_id` DESC, RAND()
LIMIT 10
Command completed in 0.00065112113952637 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.0002751350402832 seconds - 42 row(s) affected.
