Nurse Practitioners

Hide

Accessibility Tools

Hide

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.

North Campus

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

South Campus

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

East Campus

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.00011 seconds (1.22%)
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/common/common.php	require_once()	5
/home/csogy/public_html/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	require_once()	3

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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/' 
        OR T.is_global = 1
    ) 
ORDER BY 
    T.is_global ASC, 
    T.id DESC

duration: 0.00042 seconds (4.49%)
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/common/common.php	require_once()	5
/home/csogy/public_html/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	require_once()	3

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('3', p.provider_type) > 0

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

num
6

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	33

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('3', p.provider_type) > 0 
GROUP BY 
    p.id 
ORDER BY 
    p.last_name ASC 
LIMIT 
    0, 50

duration: 0.00112 seconds (11.86%)
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	specialties	locations
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	33

005

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 = '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.00043 seconds (4.54%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

006

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.00033 seconds (3.51%)
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

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 = '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.00031 seconds (3.26%)
returned rows: 0
explain
backtrace
SET UP
to the top
close all

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

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 = '123' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

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

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

009

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 = '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.00035 seconds (3.67%)
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

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 = '48' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

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

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

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 = '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.00057 seconds (6.05%)
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

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 = '59' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

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

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

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 = '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 (3.46%)
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

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 = '60' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

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

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

015

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 = '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.00037 seconds (3.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
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	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	93

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 = '51' 
    and sp.parent_id = 0 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name

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

id	select_type	table	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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	94

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' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/nurse-practitioners-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=adbf53d4138883daf6f46484e5767368',
  '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' => '1922844-609-363',
  'H2_STREAM_ID' => '363',
  '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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-ewC7ojUlkocvPDucAwABDxE',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-363',
  'REDIRECT_H2_STREAM_ID' => '363',
  '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/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-ewC7ojUlkocvPDucAwABDxE',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/nurse-practitioners-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702971.2632400989532470703125,
  'REQUEST_TIME' => 1794702971,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

16! / 0