Physician Assistants & Nurse Practitioners | Colorado Springs Orthopaedic Group | Orthopaedic Specialists Colorado Springs | Orthopaedic Care CO

Hide

Accessibility Tools

Physician Assistants & Nurse Practitioners

Physician Assistants
Nurse Practitioners

Physician Assistants

Nurse Practitioners

Related Links

Colorado Springs Locations

Orthopaedic Care Across Colorado Springs

Visit CSOG at convenient locations for specialty care, Express Care, imaging, therapy, and recovery support.

4110 Briargate Parkway
Suite 300
Colorado Springs, CO 80920

Mon - Thu : 7:00 am to 5:00 pm
Fri : 7:00 am to 4:00 pm

Schedule an Appointment

1655 Quail Lake Loop
Colorado Springs, CO 80906

Mon - Thu : 7:00 am to 5:00 pm
Fri : 7:00 am to 4:00 pm

Schedule an Appointment

6140 Tutt Blvd
Suite 110
Colorado Springs, CO 80923

Mon - Fri : 7:00 am to 6:00 pm

Schedule an Appointment

Ready to Take the Next Step Toward Better Movement?

Whether you are dealing with a new injury, chronic pain, arthritis, or recovery after surgery, CSOG can help you find the right orthopaedic care path.

001

SET 
    NAMES "utf8mb4" COLLATE "utf8mb4_unicode_ci"

duration: 0.00014 seconds (0.90%)
affected rows: 0
backtrace
SET UP
to the top
close all

File	Function	Line
/home/csogy/public_html/database/Zebra_Database.php	query()	3907
/home/csogy/public_html/helpers/functions.php	set_charset()	42
/home/csogy/public_html/models/YpoDatabase.php	getConnection()	22
/home/csogy/public_html/models/Provider.php	__construct()	27
/home/csogy/public_html/configs/common.php	__construct()	182
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	require_once()	2

002

SELECT 
    DISTINCT T.* 
FROM 
    cs_page_alerts T 
    LEFT JOIN cs_page_alerts_page_urls PU ON (
        PU.page_alert_id = T.id 
        AND T.is_global = 0
    ) 
WHERE 
    T.status = '1' 
    AND (
        PU.page_url = 'https://csog.ypo.pw/physician-assistants-orthopaedic-specialists-colorado-springs-co/' 
        OR T.is_global = 1
    ) 
ORDER BY 
    T.is_global ASC, 
    T.id DESC

duration: 0.00042 seconds (2.77%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	T		ALL					3	33.33	Using where; Using temporary; Using filesort
1	SIMPLE	PU		ALL					3	100.00	Using where; Distinct; Using join buffer (hash join)

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/PageAlert.php	rawQuery()	67
/home/csogy/public_html/models/PageAlert.php	getCurrentPageAlerts()	76
/home/csogy/public_html/configs/common.php	getCurrentPageAlertsGrouped()	185
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	require_once()	2

003

SELECT 
    COUNT(DISTINCT p.id) AS num 
FROM 
    cs_providers p 
    INNER JOIN cs_provider_type pt ON FIND_IN_SET(pt.id, p.provider_type) > 0 
    LEFT JOIN cs_provider_specialties ps ON ps.provider_id = p.id 
    LEFT JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_provider_locations pl ON pl.provider_id = p.id 
    LEFT JOIN cs_locations l ON l.id = pl.location_id 
    LEFT JOIN cs_provider_certifications c ON c.provider_id = p.id 
WHERE 
    1 
    AND p.status = 1 
    AND FIND_IN_SET('2', p.provider_type) > 0

duration: 0.00077 seconds (5.08%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

num
14

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pt		index		PRIMARY	4		6	100.00	Using index
1	SIMPLE	p		ALL					91	10.00	Using where; Using join buffer (hash join)
1	SIMPLE	ps		ALL					80	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	sp		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	100.00	Using index
1	SIMPLE	pl		ALL					153	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	l		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.pl.location_id	1	100.00	Using index
1	SIMPLE	c		ALL					78	100.00	Using where; Using join buffer (hash join)

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	146
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	36

004

SELECT 
    p.id, 
    p.first_name, 
    p.last_name, 
    p.short_title, 
    p.photo, 
    p.status, 
    pt.type AS provider_type, 
    pt.sh_name, 
    p.degree, 
    p.designation, 
    p.slug, 
    p.review_url, 
    GROUP_CONCAT(
        DISTINCT CONCAT(
            sp.id, '//*//', sp.slug, '//*//', sp.specialty_name
        ) 
        ORDER BY 
            sp.specialty_name SEPARATOR ', '
    ) AS specialties, 
    GROUP_CONCAT(
        DISTINCT l.location_name 
        ORDER BY 
            l.location_name SEPARATOR '  '
    ) AS locations, 
    GROUP_CONCAT(DISTINCT c.certificate_type) as c_type 
FROM 
    cs_providers p 
    INNER JOIN cs_provider_type pt ON FIND_IN_SET(pt.id, p.provider_type) > 0 
    LEFT JOIN cs_provider_specialties ps ON ps.provider_id = p.id 
    LEFT JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_provider_locations pl ON pl.provider_id = p.id 
    LEFT JOIN cs_locations l ON l.id = pl.location_id 
    LEFT JOIN cs_provider_certifications c ON c.provider_id = p.id 
WHERE 
    1 
    AND p.status = 1 
    AND FIND_IN_SET('2', p.provider_type) > 0 
GROUP BY 
    p.id 
ORDER BY 
    p.last_name ASC 
LIMIT 
    0, 1000

duration: 0.00092 seconds (6.10%)
returned rows: 14
explain
backtrace
SET UP
to the top
close all

id	first_name	last_name	short_title	photo	status	provider_type	sh_name	degree	designation	slug	review_url	specialties	locations	c_type
41	Mattie	Batchelder, PA-C	Mattie Batchelder, PA-C	mattie-batchelder-pa-c-1784569975.png	1	Physician Assistant	PA			mattie-batchelder-pa-c			North Campus South Campus
130	Heidi	Bennett, PA-C	Heidi Bennett, PA-C	hiedi-bennett-pac-1790581352.jpg	1	Physician Assistant	PA			heidi-bennett-pa-c
42	Julia	Beski, PA-C	Julia Beski, PA-C	julia-beski-new-1791200195.jpg	1	Physician Assistant	PA			julia-beski-pa-c			North Campus South Campus	Board Certifications
43	Christian	Birky, PA-C	Christian Birky, PA-C	christian-birky-pa-c-1784570280.png	1	Physician Assistant	PA			christian-birky-pa-c			North Campus South Campus
126	Rebecca	DeBalski, PA-C	Rebecca DeBalski, PA-C	rebecca-debalski-pac-1790826550.jpg	1	Physician Assistant	PA			rebecca-debalski-pa-c			North Campus South Campus
49	Nicole	Derby, PA-C	Nicole Derby, PA-C	nicole-derby-pa-c-1784569924.png	1	Physician Assistant	PA			nicole-derby-pa-c			North Campus South Campus	,Certifications,Honors,Memberships
54	Phillip	Falender, PA-C	Phillip Falender, PA-C	phillip-falender-1791190973.jpg	1	Physician Assistant	PA			phillip-falender-pa-c			North Campus South Campus	Certification
57	Millie	Livingston, PA-C	Millie Livingston, PA-C	millie-livingson-pa-c-1784570343.png	1	Physician Assistant	PA			millie-livingston-pa-c			North Campus South Campus
64	Kristina	O'Brien, PA-C	Kristina O'Brien, PA-C	kristina-o-brien-pa-c-1784569697.png	1	Physician Assistant	PA			kristina-o-brien-pa-c			North Campus	Certification,Memberships
63	Devin	Pao, PA-C	Devin Pao, PA-C	devin-pao-pa-c-1784569902.png	1	Physician Assistant	PA	PA		devin-pao-pa-c			North Campus South Campus
62	Megan	Perry, PA-C	Megan Perry, PA-C	megan-perry-pa-c-1784570089.png	1	Physician Assistant	PA	PS		megan-perry-pa-c			North Campus South Campus	Certification
61	Robert	Peterson, PA-C	Robert Peterson, PA-C	robert-peterson-pa-c-1784570126.png	1	Physician Assistant	PA	PA		robert-peterson-pa-c			North Campus South Campus
58	Kristen	Reiss, PA-C	Kristen Reiss, PA-C	kristen-reiss-pa-c-1784570323.png	1	Physician Assistant	PA	PA		kristen-reiss-pa-c			North Campus South Campus	Certifications,Memberships
53	Tyler	Walker, PA-C	Tyler Walker, PA-C	tyler-walker-pa-c-1784570216.png	1	Physician Assistant	PA	PA		tyler-walker-pa-c

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pt		ALL					6	100.00	Using temporary; Using filesort
1	SIMPLE	p		ALL	PRIMARY				91	10.00	Using where; Using join buffer (hash join)
1	SIMPLE	ps		ALL					80	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	sp		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	100.00
1	SIMPLE	pl		ALL					153	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	l		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.pl.location_id	1	100.00
1	SIMPLE	c		ALL					78	100.00	Using where; Using join buffer (hash join)

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	156
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	36

005

SELECT 
    COUNT(DISTINCT p.id) AS num 
FROM 
    cs_providers p 
    INNER JOIN cs_provider_type pt ON FIND_IN_SET(pt.id, p.provider_type) > 0 
    LEFT JOIN cs_provider_specialties ps ON ps.provider_id = p.id 
    LEFT JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_provider_locations pl ON pl.provider_id = p.id 
    LEFT JOIN cs_locations l ON l.id = pl.location_id 
    LEFT JOIN cs_provider_certifications c ON c.provider_id = p.id 
WHERE 
    1 
    AND p.status = 1 
    AND FIND_IN_SET('3', p.provider_type) > 0

duration: 0.00051 seconds (3.36%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

num
6

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pt		index		PRIMARY	4		6	100.00	Using index
1	SIMPLE	p		ALL					91	10.00	Using where; Using join buffer (hash join)
1	SIMPLE	ps		ALL					80	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	sp		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	100.00	Using index
1	SIMPLE	pl		ALL					153	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	l		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.pl.location_id	1	100.00	Using index
1	SIMPLE	c		ALL					78	100.00	Using where; Using join buffer (hash join)

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	146
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	52

006

SELECT 
    p.id, 
    p.first_name, 
    p.last_name, 
    p.short_title, 
    p.photo, 
    p.status, 
    pt.type AS provider_type, 
    pt.sh_name, 
    p.degree, 
    p.designation, 
    p.slug, 
    p.review_url, 
    GROUP_CONCAT(
        DISTINCT CONCAT(
            sp.id, '//*//', sp.slug, '//*//', sp.specialty_name
        ) 
        ORDER BY 
            sp.specialty_name SEPARATOR ', '
    ) AS specialties, 
    GROUP_CONCAT(
        DISTINCT l.location_name 
        ORDER BY 
            l.location_name SEPARATOR '  '
    ) AS locations, 
    GROUP_CONCAT(DISTINCT c.certificate_type) as c_type 
FROM 
    cs_providers p 
    INNER JOIN cs_provider_type pt ON FIND_IN_SET(pt.id, p.provider_type) > 0 
    LEFT JOIN cs_provider_specialties ps ON ps.provider_id = p.id 
    LEFT JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_provider_locations pl ON pl.provider_id = p.id 
    LEFT JOIN cs_locations l ON l.id = pl.location_id 
    LEFT JOIN cs_provider_certifications c ON c.provider_id = p.id 
WHERE 
    1 
    AND p.status = 1 
    AND FIND_IN_SET('3', p.provider_type) > 0 
GROUP BY 
    p.id 
ORDER BY 
    p.last_name ASC 
LIMIT 
    0, 1000

duration: 0.00073 seconds (4.80%)
returned rows: 6
explain
backtrace
SET UP
to the top
close all

id	first_name	last_name	short_title	photo	status	provider_type	sh_name	degree	designation	slug	review_url	specialties	locations	c_type
44	Whitney	Boston, FNP	Whitney Boston, FNP	whitney-boston-fnp-1784569948.png	1	Nurse Practitioner	NP		Bone Health	whitney-boston-fnp		38////bone-health////Bone Health	North Campus South Campus
123	Teresa	Constantino, NP	Teresa Constantino, NP	teresa-constantino-pac-1790568041.jpg	1	Express Care Provider	ECP		Express Care	teresa-constantino-np			North Campus South Campus
48	Jenielle	Daugherty, NP	Jenielle Daugherty, NP	jenielle-daugherty-np-1784570437.png	1	Nurse Practitioner	NP			jenielle-daugherty-np			North Campus South Campus
59	Ellen	Lopez, NP	Ellen Lopez, NP	ellen-lopez-np-1784570191.png	1	Nurse Practitioner	NP			ellen-lopez-np			East Campus South Campus
60	Taylor	Pinto, NP	Taylor Pinto, NP	taylor-pinto-np-1784570003.png	1	Nurse Practitioner	NP	NP		taylor-pinto-np			North Campus South Campus
51	Jasmine	Wohlman, NP	Jasmine Wohlman, NP	jasmine-wohlman-np-1784570365.png	1	Nurse Practitioner	NP	NP		jasmine-wohlman-np

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pt		ALL					6	100.00	Using temporary; Using filesort
1	SIMPLE	p		ALL	PRIMARY				91	10.00	Using where; Using join buffer (hash join)
1	SIMPLE	ps		ALL					80	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	sp		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	100.00
1	SIMPLE	pl		ALL					153	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	l		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.pl.location_id	1	100.00
1	SIMPLE	c		ALL					78	100.00	Using where; Using join buffer (hash join)

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	156
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	52

007

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '41' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00040 seconds (2.66%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
24	douglas-adams-md	Douglas	Adams, MD	Douglas Adams, MD	Sports Medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

008

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '41' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.34%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

009

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '130' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00038 seconds (2.48%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
124	christopher-malinky-md	Christopher	Malinky, MD	Christopher Malinky, MD	Pain Management	/pain-management-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

010

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '130' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.31%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

011

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '42' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00043 seconds (2.87%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
29	michael-feign-do	Michael	Feign, DO	Michael Feign, DO	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

012

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '42' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.33%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

013

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '43' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00040 seconds (2.62%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
36	roger-d-sung-md	Roger D.	Sung, MD	Roger D. Sung, MD	Spine	/spine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

014

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '43' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.30%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

015

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '126' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00037 seconds (2.43%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
39	craig-a-yager-md	Craig	Yager, MD	Craig A. Yager, MD	Sports Medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

016

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '126' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.27%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

017

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '49' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00041 seconds (2.70%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
31	jamie-l-friedman-md	Jamie L.	Friedman, MD	Jamie L. Friedman, MD	Sports Medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

018

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '49' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00022 seconds (1.42%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

019

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '54' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00039 seconds (2.57%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
33	john-c-redfern-md	John C.	Redfern, MD	John C. Redfern, MD	Sports Medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

020

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '54' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.34%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

021

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '57' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00037 seconds (2.41%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
36	roger-d-sung-md	Roger D.	Sung, MD	Roger D. Sung, MD	Spine	/spine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

022

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '57' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.30%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

023

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '64' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00037 seconds (2.45%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
28	brad-d-dresher-md	Brad D.	Dresher, MD	Brad D. Dresher, MD	Foot Ankle	/foot-ankle-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

024

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '64' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.30%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

025

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '63' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00044 seconds (2.91%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
26	tyler-bron-md	Tyler	Bron, MD	Tyler Bron, MD	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

026

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '63' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.29%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

027

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '62' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00035 seconds (2.33%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
27	dale-cassidy-md-mba	Dale	Cassidy, MD, MBA	Dale Cassidy, MD, MBA	Hand & Wrist	/hand-wrist-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

028

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '62' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.28%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

029

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '61' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00043 seconds (2.85%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
32	eric-k-jepson-do	Eric K.	Jepson, DO	Eric K. Jepson, DO	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

030

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '61' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.25%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

031

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '58' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00037 seconds (2.47%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
39	craig-a-yager-md	Craig	Yager, MD	Craig A. Yager, MD	Sports Medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

032

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '58' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.28%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

033

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '53' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC

duration: 0.00042 seconds (2.78%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
26	tyler-bron-md	Tyler	Bron, MD	Tyler Bron, MD	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	68
/home/csogy/public_html/models/Provider.php	rawQuerySingle()	688
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	114

034

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '53' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.35%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	115

035

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '44' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00029 seconds (1.94%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

036

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '44' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00023 seconds (1.49%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
38	Bone Health	bone-health	0	/bone-health-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

037

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '123' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00029 seconds (1.90%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

038

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '123' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.27%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

039

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '48' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00032 seconds (2.15%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
35	paul-stanton-do	Paul	Stanton, DO	Paul Stanton, DO	Spine	/spine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

040

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '48' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.26%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

041

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '59' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00054 seconds (3.55%)
returned rows: 2
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
26	tyler-bron-md	Tyler	Bron, MD	Tyler Bron, MD	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
32	eric-k-jepson-do	Eric K.	Jepson, DO	Eric K. Jepson, DO	Joint Replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

042

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '59' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.27%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

043

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '60' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00033 seconds (2.21%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
35	paul-stanton-do	Paul	Stanton, DO	Paul Stanton, DO	Spine	/spine-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

044

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '60' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00019 seconds (1.27%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

045

SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = T.id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '51' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC;

duration: 0.00038 seconds (2.49%)
returned rows: 1
explain
backtrace
SET UP
to the top
close all

id	slug	first_name	last_name	short_title	specialty_name	s_page_url
34	g-alex-simpson-do	G. Alex	Simpson, DO	G. Alex Simpson, DO	Foot Ankle	/foot-ankle-orthopaedic-specialists-colorado-springs-co/

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	PA		ALL					35	10.00	Using where; Using temporary; Using filesort
1	PRIMARY	T		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PA.doctor_id	1	10.00	Using where
1	PRIMARY	PS		ALL					80	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	S		eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.PS.specialty_id	1	100.00
2	DEPENDENT SUBQUERY	ps_sub		ALL					80	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	716
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitentMult()	173

046

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '51' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

duration: 0.00020 seconds (1.30%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps		ALL					80	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	sp		eq_ref	PRIMARY,idx_parent	PRIMARY	4	csogy_csog_db.ps.specialty_id	1	76.00	Using where
1	SIMPLE	parent		const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Provider.php	rawQuery()	198
/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	174

001	$_REQUEST array ( )

001	$_POST array ( )

001	$_GET array ( 'page' => 1, )

001	$_SESSION array ( )

001	$_FILES array ( )

001

$_SERVER

array (
  'USER' => 'csogy',
  'HOME' => '/home/csogy',
  'SCRIPT_NAME' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '7420',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/physician-assistants-orthopaedic-specialists-colorado-springs-co.php',
  'SERVER_ADMIN' => 'webmaster@csog.ypo.pw',
  'CONTEXT_DOCUMENT_ROOT' => '/home/csogy/public_html',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'https',
  'DOCUMENT_ROOT' => '/home/csogy/public_html',
  'REMOTE_ADDR' => '216.73.216.171',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '172.31.81.87',
  'SERVER_NAME' => 'csog.ypo.pw',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin',
  'HTTP_X_HTTPS' => '1',
  'HTTP_HOST' => 'csog.ypo.pw',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_COOKIE' => 'PHPSESSID=3bda1cb3c7e7825da44ff85b74dc0e09',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'proxy-nokeepalive' => '1',
  'H2_STREAM_TAG' => '1877161-606-289',
  'H2_STREAM_ID' => '289',
  'H2_PUSHED_ON' => '',
  'H2_PUSHED' => '',
  'H2_PUSH' => 'off',
  'H2PUSH' => 'off',
  'HTTP2' => 'on',
  'SSL_TLS_SNI' => 'csog.ypo.pw',
  'HTTPS' => 'on',
  'GOOGLE_APPLICATION_CREDENTIALS' => '/home/csogy/public_html/mobileapp/notifications/config/firebase-service-account.json',
  'HTTP_AUTHORIZATION' => '',
  'SCRIPT_URI' => 'https://csog.ypo.pw/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj8I9nzTe5gLFgPBCW_PgAA0Q0',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1877161-606-289',
  'REDIRECT_H2_STREAM_ID' => '289',
  'REDIRECT_H2_PUSHED_ON' => '',
  'REDIRECT_H2_PUSHED' => '',
  'REDIRECT_H2_PUSH' => 'off',
  'REDIRECT_H2PUSH' => 'off',
  'REDIRECT_HTTP2' => 'on',
  'REDIRECT_SSL_TLS_SNI' => 'csog.ypo.pw',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_GOOGLE_APPLICATION_CREDENTIALS' => '/home/csogy/public_html/mobileapp/notifications/config/firebase-service-account.json',
  'REDIRECT_HTTP_AUTHORIZATION' => '',
  'REDIRECT_SCRIPT_URI' => 'https://csog.ypo.pw/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj8I9nzTe5gLFgPBCW_PgAA0Q0',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/physician-assistants-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702371.38346004486083984375,
  'REQUEST_TIME' => 1794702371,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

46! / 0