Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.page_title AS page_title_5,
  t0.og_title AS og_title_6,
  t0.og_description AS og_description_7,
  t0.keywords AS keywords_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.thumbnail_id AS thumbnail_id_11
FROM
  page_metadata t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.page_title AS page_title_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.keywords AS keywords_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail_id AS thumbnail_id_11 FROM page_metadata t0 WHERE t0.slug = 'team-page' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.metadata_id AS metadata_id_6
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.metadata_id AS metadata_id_6 FROM category t0;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.weight AS weight_3,
  s0_.editor_state AS editor_state_4,
  s0_.html_content AS html_content_5,
  c1_.id AS id_6,
  c1_.name AS name_7,
  c1_.slug AS slug_8,
  c1_.created_at AS created_at_9,
  c1_.updated_at AS updated_at_10,
  s0_.category_id AS category_id_11,
  s0_.metadata_id AS metadata_id_12,
  c1_.metadata_id AS metadata_id_13
FROM
  surgery s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, c1_.id AS id_6, c1_.name AS name_7, c1_.slug AS slug_8, c1_.created_at AS created_at_9, c1_.updated_at AS updated_at_10, s0_.category_id AS category_id_11, s0_.metadata_id AS metadata_id_12, c1_.metadata_id AS metadata_id_13 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '16' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '17' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '18' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '19' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '20' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '21' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '22' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '23' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '24' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '25' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '26' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '27' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '28' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '29' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '30' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.first_name AS first_name_2,
  p0_.last_name AS last_name_3,
  p0_.slug AS slug_4,
  p0_.degrees AS degrees_5,
  p0_.certifications AS certifications_6,
  p0_.office_phone AS office_phone_7,
  p0_.office_address AS office_address_8,
  p0_.email AS email_9,
  p0_.vip_level AS vip_level_10,
  p0_.position AS position_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.linkedin_profile AS linkedin_profile_14,
  p0_.picture_id AS picture_id_15,
  p0_.metadata_id AS metadata_id_16
FROM
  practitioner p0_
  INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug <> 'anesthesiology'
  AND p0_.last_name LIKE ?
ORDER BY
  p0_.last_name ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.first_name AS first_name_2, p0_.last_name AS last_name_3, p0_.slug AS slug_4, p0_.degrees AS degrees_5, p0_.certifications AS certifications_6, p0_.office_phone AS office_phone_7, p0_.office_address AS office_address_8, p0_.email AS email_9, p0_.vip_level AS vip_level_10, p0_.position AS position_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.linkedin_profile AS linkedin_profile_14, p0_.picture_id AS picture_id_15, p0_.metadata_id AS metadata_id_16 FROM practitioner p0_ INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug <> 'anesthesiology' AND p0_.last_name LIKE 'X%' ORDER BY p0_.last_name ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.first_name AS first_name_2,
  p0_.last_name AS last_name_3,
  p0_.slug AS slug_4,
  p0_.degrees AS degrees_5,
  p0_.certifications AS certifications_6,
  p0_.office_phone AS office_phone_7,
  p0_.office_address AS office_address_8,
  p0_.email AS email_9,
  p0_.vip_level AS vip_level_10,
  p0_.position AS position_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.linkedin_profile AS linkedin_profile_14,
  p0_.picture_id AS picture_id_15,
  p0_.metadata_id AS metadata_id_16
FROM
  practitioner p0_
  INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug = 'anesthesiology'
ORDER BY
  p0_.last_name ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.first_name AS first_name_2, p0_.last_name AS last_name_3, p0_.slug AS slug_4, p0_.degrees AS degrees_5, p0_.certifications AS certifications_6, p0_.office_phone AS office_phone_7, p0_.office_address AS office_address_8, p0_.email AS email_9, p0_.vip_level AS vip_level_10, p0_.position AS position_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.linkedin_profile AS linkedin_profile_14, p0_.picture_id AS picture_id_15, p0_.metadata_id AS metadata_id_16 FROM practitioner p0_ INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug = 'anesthesiology' ORDER BY p0_.last_name ASC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '24' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Practitioner';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?