0.31 ms
(24.26%)
|
1 |
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 'J%' ORDER BY p0_.last_name ASC;
|
0.24 ms
(19.04%)
|
1 |
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;
|
0.19 ms
(15.13%)
|
6 |
SELECT t0.file_path AS file_path_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM static_media_object t0 WHERE t0.id = ?
Parameters: [
b"\x01›¡ZÑ\x7F\x1C†m`9\x04\x1CÂë"
]
SELECT t0.file_path AS file_path_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM static_media_object t0 WHERE t0.id = 0x019BADA15AD17F1C866D6039041CC2EB;
|
0.19 ms
(14.43%)
|
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 = ? LIMIT 1
Parameters: [
"team-page"
]
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;
|
0.18 ms
(14.28%)
|
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.weight AS weight_4, t0.editor_state AS editor_state_5, t0.html_content AS html_content_6, t0.category_id AS category_id_7, t0.metadata_id AS metadata_id_8 FROM surgery t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.weight AS weight_4, t0.editor_state AS editor_state_5, t0.html_content AS html_content_6, t0.category_id AS category_id_7, t0.metadata_id AS metadata_id_8 FROM surgery t0 WHERE t0.category_id = 5;
|
0.09 ms
(7.25%)
|
1 |
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;
|
0.07 ms
(5.61%)
|
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;
|