Our Providers | Colorado Springs Orthopaedic Group | Orthopaedic Specialists Colorado Springs

Hide

Accessibility Tools

Hide

CSOGSpecialized Physicians

Douglas Adams, MD

Fellowship Trained and Board Certified Orthopedic Surgeon
Expertise
- Sports Medicine
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Tyler Bron, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Dale Cassidy, MD, MBA

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Hand & Wrist
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Brad D. Dresher, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Foot Ankle
- Trauma & Fracture Care
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Michael Feign, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
D. Alex Forrester, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Jamie L. Friedman, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Eric K. Jepson, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Christopher Malinky, MD

Fellowship Trained & Board Certified Physician
Expertise
- Pain Management
- Spine
South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Benjamin Meyer, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Sports Medicine
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Brendan Mitchell, MD

Fellowship Trained & Board Eligible Orthopedic Surgeon
Expertise
- Spine
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
John C. Redfern, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
G. Alex Simpson, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Foot Ankle
- Trauma & Fracture Care
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Paul Stanton, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Spine
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Roger D. Sung, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
- Alternative Therapy Treatments
- Spine
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Michael Van Manen, DO

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment
Craig A. Yager, MD

Fellowship Trained & Board Certified Orthopedic Surgeon
Expertise
North Campus South Campus
- View Profile
- Read Reviews
Schedule an Appointment

NursePractitioners & Physician Assistants

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.00013 seconds (0.51%)
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/our-providers-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/our-providers-orthopaedic-specialists-colorado-springs-co/' 
        OR T.is_global = 1
    ) 
ORDER BY 
    T.is_global ASC, 
    T.id DESC

duration: 0.00045 seconds (1.72%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	require_once()	3

003

SELECT 
    id, 
    location_name, 
    slug 
FROM 
    cs_locations 
WHERE 
    status = '1' 
    AND id != 5

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

id	location_name	slug
1	North Campus	north-campus
2	South Campus	south-campus

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cs_locations		range	PRIMARY	PRIMARY	4		3	33.33	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Location.php	rawQuery()	19
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getActiveLocation()	29

004

SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id 
FROM 
    cs_specialties sp 
    INNER JOIN cs_provider_specialties ps ON ps.specialty_id = sp.id 
    INNER JOIN cs_providers p ON p.id = ps.provider_id 
WHERE 
    sp.status = '1' 
    AND p.status = '1' 
    AND sp.parent_id = '0' 
GROUP BY 
    sp.id 
ORDER BY 
    sp.specialty_name

duration: 0.00121 seconds (4.65%)
returned rows: 15
explain
backtrace
SET UP
to the top
close all

id	specialty_name	slug
36	Alternative Therapy Treatments	alternative-therapy-treatments
32	Arthritis Disease Management	arthritis-disease-management
37	Audubon Orthotic & Prosthetic Services	audubon-orthotic-prosthetic-services
38	Bone Health	bone-health
16	Foot Ankle	foot-ankle
1	Hand & Wrist	hand-wrist
14	Hip	hip
23	Joint Replacement	joint-replacement
15	Knee	knee
34	Orthopedic Surgery	orthopedic-surgery
18	Pain Management	pain-management
4	Shoulder	shoulder
13	Spine	spine
17	Sports Medicine	sports-medicine
33	Trauma & Fracture Care	trauma-fracture-care

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	ref	PRIMARY,idx_parent	idx_parent	5	const	19	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	ps	ALL					80	10.00	Using where; Using join buffer (hash join)
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	csogy_csog_db.ps.provider_id	1	10.00	Using where

File	Function	Line
/home/csogy/public_html/models/YpoDatabase.php	query()	47
/home/csogy/public_html/models/Speciality.php	rawQuery()	102
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getActiveSpecalityList()	30

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

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

num
17

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	73

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

duration: 0.00224 seconds (8.63%)
returned rows: 17
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
24	Douglas	Adams, MD	Douglas Adams, MD	douglas-adams-md-1784632621.png	1	Doctor	MD		Fellowship Trained and Board Certified Orthopedic Surgeon	douglas-adams-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=156505	31////general-orthopedics////General Orthopedics, 17////sports-medicine////Sports Medicine	North Campus South Campus	,Memberships & Board Certification
26	Tyler	Bron, MD	Tyler Bron, MD	tyler-bron-md-1784652250.png	1	Doctor	MD	MD	Fellowship Trained & Board Certified Orthopedic Surgeon	tyler-bron-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=126368	32////arthritis-disease-management////Arthritis Disease Management, 31////general-orthopedics////General Orthopedics, 14////hip////Hip, 23////joint-replacement////Joint Replacement, 15////knee////Knee, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus
27	Dale	Cassidy, MD, MBA	Dale Cassidy, MD, MBA	dale-cassidy-md-1784652284.png	1	Doctor	MD	MD	Fellowship Trained & Board Certified Orthopedic Surgeon	dale-cassidy-md-mba	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5713	1////hand-wrist////Hand & Wrist	North Campus South Campus	,Board Certified,Memberships
28	Brad D.	Dresher, MD	Brad D. Dresher, MD	brad-d-dresher-md-1784567275.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	brad-d-dresher-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5714	16////foot-ankle////Foot Ankle, 31////general-orthopedics////General Orthopedics, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	Board Certified
29	Michael	Feign, DO	Michael Feign, DO	michael-feign-do-1784567177.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	michael-feign-do	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=138894	31////general-orthopedics////General Orthopedics, 14////hip////Hip, 23////joint-replacement////Joint Replacement, 15////knee////Knee, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	Board Certified
30	D. Alex	Forrester, MD	D. Alex Forrester, MD	d-alex-forrester-md-1784567112.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	d-alex-forrester-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=154813	32////arthritis-disease-management////Arthritis Disease Management, 31////general-orthopedics////General Orthopedics, 14////hip////Hip, 23////joint-replacement////Joint Replacement, 15////knee////Knee, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	,Memberships
31	Jamie L.	Friedman, MD	Jamie L. Friedman, MD	jamie-l-friedman-md-1784567065.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	jamie-l-friedman-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=135366	31////general-orthopedics////General Orthopedics, 15////knee////Knee, 4////shoulder////Shoulder, 17////sports-medicine////Sports Medicine, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	,Memberships & Board Certification,Team Physician (2019-2020)
32	Eric K.	Jepson, DO	Eric K. Jepson, DO	eric-k-jepson-do-1784567040.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	eric-k-jepson-do	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5718	32////arthritis-disease-management////Arthritis Disease Management, 31////general-orthopedics////General Orthopedics, 14////hip////Hip, 23////joint-replacement////Joint Replacement, 15////knee////Knee, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	Awards,Board Certified
124	Christopher	Malinky, MD	Christopher Malinky, MD	dr-malinky-1789030532.png	1	Doctor	MD		Fellowship Trained & Board Certified Physician	christopher-malinky-md		18////pain-management////Pain Management, 13////spine////Spine	South Campus
121	Benjamin	Meyer, DO	Benjamin Meyer, DO	benjamin-meyer-do-1787569723.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	benjamin-meyer-do		17////sports-medicine////Sports Medicine	North Campus South Campus
125	Brendan	Mitchell, MD	Brendan Mitchell, MD	dr-brendan-mitchell-1790581119.jpg	1	Doctor	MD		Fellowship Trained & Board Eligible Orthopedic Surgeon	brendan-mitchell-md		13////spine////Spine	North Campus South Campus
33	John C.	Redfern, MD	John C. Redfern, MD	john-c-redfern-md-1784566994.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	john-c-redfern-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5722	31////general-orthopedics////General Orthopedics, 4////shoulder////Shoulder, 17////sports-medicine////Sports Medicine, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus	Awards,Board Certified,Membership
34	G. Alex	Simpson, DO	G. Alex Simpson, DO	g-alex-simpson-do-1784566965.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	g-alex-simpson-do	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=138896	16////foot-ankle////Foot Ankle, 31////general-orthopedics////General Orthopedics, 33////trauma-fracture-care////Trauma & Fracture Care	North Campus South Campus
35	Paul	Stanton, DO	Paul Stanton, DO	paul-stanton-do-1784566764.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	paul-stanton-do	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5723	13////spine////Spine	North Campus South Campus	,Board Certified,Membership
36	Roger D.	Sung, MD	Roger D. Sung, MD	roger-d-sung-md-1784566737.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	roger-d-sung-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=5726	36////alternative-therapy-treatments////Alternative Therapy Treatments, 35////image-guided-surgery-stealth-x-vision////Image Guided Surgery (Stealth, X-Vision), 13////spine////Spine	North Campus South Campus	Board Certified
37	Michael	Van Manen, DO	Michael Van Manen, DO	michael-van-manen-do-1784566704.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	michael-van-manen-do	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=149581	32////arthritis-disease-management////Arthritis Disease Management, 31////general-orthopedics////General Orthopedics, 14////hip////Hip, 23////joint-replacement////Joint Replacement, 15////knee////Knee	North Campus South Campus	Board Certified
39	Craig	Yager, MD	Craig A. Yager, MD	craig-a-yager-md-1784566587.png	1	Doctor	MD		Fellowship Trained & Board Certified Orthopedic Surgeon	craig-a-yager-md	https://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=138842	34////orthopedic-surgery////Orthopedic Surgery, 4////shoulder////Shoulder, 17////sports-medicine////Sports Medicine	North Campus South Campus	,Board Certified,Membership

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	73

007

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

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

num
20

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	86

008

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

duration: 0.00094 seconds (3.62%)
returned rows: 20
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	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
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
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
59	Ellen	Lopez, NP	Ellen Lopez, NP	ellen-lopez-np-1784570191.png	1	Nurse Practitioner	NP			ellen-lopez-np		East 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
60	Taylor	Pinto, NP	Taylor Pinto, NP	taylor-pinto-np-1784570003.png	1	Nurse Practitioner	NP	NP		taylor-pinto-np		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
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getListOfRecords()	86

009

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
17	Sports Medicine	sports-medicine	0	/sports-medicine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

010

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '24'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	24	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	24	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

011

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

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

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

id	specialty_name	slug	page_url
32	Arthritis Disease Management	arthritis-disease-management
14	Hip	hip	/hip-orthopaedic-specialists-colorado-springs-co/
23	Joint Replacement	joint-replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
15	Knee	knee	/knee-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

012

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '26'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	26	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	26	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

013

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
1	Hand & Wrist	hand-wrist	0	/hand-wrist-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

014

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '27'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	27	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	27	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

015

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
16	Foot Ankle	foot-ankle	0	/foot-ankle-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care	0

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

016

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '28'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	28	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	28	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

017

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

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

id	specialty_name	slug	page_url
14	Hip	hip	/hip-orthopaedic-specialists-colorado-springs-co/
23	Joint Replacement	joint-replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
15	Knee	knee	/knee-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

018

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '29'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	29	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	29	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

019

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

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

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

id	specialty_name	slug	page_url
32	Arthritis Disease Management	arthritis-disease-management
14	Hip	hip	/hip-orthopaedic-specialists-colorado-springs-co/
23	Joint Replacement	joint-replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
15	Knee	knee	/knee-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

020

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '30'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	30	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	30	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

021

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

duration: 0.00021 seconds (0.82%)
returned rows: 4
explain
backtrace
SET UP
to the top
close all

id	specialty_name	slug	page_url
15	Knee	knee	/knee-orthopaedic-specialists-colorado-springs-co/
4	Shoulder	shoulder	/shoulder-orthopaedic-specialists-colorado-springs-co/
17	Sports Medicine	sports-medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

022

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '31'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	31	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	31	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

023

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

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

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

id	specialty_name	slug	page_url
32	Arthritis Disease Management	arthritis-disease-management
14	Hip	hip	/hip-orthopaedic-specialists-colorado-springs-co/
23	Joint Replacement	joint-replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
15	Knee	knee	/knee-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

024

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '32'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	32	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	32	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

025

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
18	Pain Management	pain-management	0	/pain-management-orthopaedic-specialists-colorado-springs-co/
13	Spine	spine	0	/spine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

026

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '124'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
2	124	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

027

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
17	Sports Medicine	sports-medicine	0	/sports-medicine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

028

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '121'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	121	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	121	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

029

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
13	Spine	spine	0	/spine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

030

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '125'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	125	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	125	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

031

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

duration: 0.00021 seconds (0.82%)
returned rows: 3
explain
backtrace
SET UP
to the top
close all

id	specialty_name	slug	page_url
4	Shoulder	shoulder	/shoulder-orthopaedic-specialists-colorado-springs-co/
17	Sports Medicine	sports-medicine	/sports-medicine-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

032

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '33'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	33	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	33	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

033

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
16	Foot Ankle	foot-ankle	0	/foot-ankle-orthopaedic-specialists-colorado-springs-co/
33	Trauma & Fracture Care	trauma-fracture-care	0

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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

034

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '34'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	34	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	34	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

035

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

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
13	Spine	spine	0	/spine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

036

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '35'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	35	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	35	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

037

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

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

id	specialty_name	slug	parent_id	page_url	parent_name	parent_slug
36	Alternative Therapy Treatments	alternative-therapy-treatments	0
13	Spine	spine	0	/spine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

038

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '36'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	36	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	36	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

039

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

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

id	specialty_name	slug	page_url
32	Arthritis Disease Management	arthritis-disease-management
14	Hip	hip	/hip-orthopaedic-specialists-colorado-springs-co/
23	Joint Replacement	joint-replacement	/joint-replacement-orthopaedic-specialists-colorado-springs-co/
15	Knee	knee	/knee-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

040

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '37'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	37	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	37	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

041

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

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

id	specialty_name	slug	page_url
34	Orthopedic Surgery	orthopedic-surgery
4	Shoulder	shoulder	/shoulder-orthopaedic-specialists-colorado-springs-co/
17	Sports Medicine	sports-medicine	/sports-medicine-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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	176

042

SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '39'

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

id	provider_id	location_id	location_name	slug	page_url	address1	address2	city	state	zip	country	phone	fax	email	latitude	longitude	image	location_description	map_iframe	emergency_contact	parking_information	status	created_at	updated_at
1	39	1	North Campus	north-campus	/contact-north-campus-orthopaedic-specialists-colorado-springs-co/	4110 Briargate Parkway Suite 300	Colorado Springs, CO			80920		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:44
2	39	2	South Campus	south-campus	/contact-south-campus-orthopaedic-specialists-colorado-springs-co/	1655 Quail Lake Loop	Colorado Springs, CO			80906		(719) 632-7669	(719) 632-0088	satyam.ypo+1@gmail.com								1		2026-08-10 11:34:52

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PL		ALL					153	10.00	Using where
1	SIMPLE	L		ALL	PRIMARY				3	33.33	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()	255
/home/csogy/public_html/our-providers-orthopaedic-specialists-colorado-springs-co.php	getLocationsByProivder()	216

043

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.00039 seconds (1.51%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

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

duration: 0.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

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 = 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.00036 seconds (1.38%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

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

duration: 0.00021 seconds (0.81%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

047

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 (1.64%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

048

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 (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

049

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.00039 seconds (1.50%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

050

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 (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

051

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.00031 seconds (1.19%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

052

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.00021 seconds (0.79%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

053

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 (1.20%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

054

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.00021 seconds (0.80%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

055

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.00036 seconds (1.38%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

056

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.00020 seconds (0.77%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

057

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 (1.44%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

058

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.00020 seconds (0.77%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

059

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 (1.58%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

060

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.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

061

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 (1.51%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

062

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 (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

063

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.00039 seconds (1.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
36	roger-d-sung-md	Roger D.	Sung, MD	Roger D. Sung, MD	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

064

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 (0.75%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

065

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 (2.21%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

066

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.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

067

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 (1.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
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

068

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.00021 seconds (0.80%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

069

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.00043 seconds (1.65%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

070

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 (0.77%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

071

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.00034 seconds (1.30%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

072

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.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

073

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.00045 seconds (1.74%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

074

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.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

075

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.00034 seconds (1.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
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

076

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.00020 seconds (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

077

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.00039 seconds (1.50%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

078

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.00020 seconds (0.75%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

079

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.00043 seconds (1.65%)
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	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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

080

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 (0.76%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

081

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 (1.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
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getPysicianProfileByAssitent()	266

082

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.00021 seconds (0.80%)
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/our-providers-orthopaedic-specialists-colorado-springs-co.php	getSpecalityList()	267

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' => '/our-providers-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '28960',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/our-providers-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_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' => '1877162-608-3',
  'H2_STREAM_ID' => '3',
  '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/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj5rkr4x6Ef3Wff6bvjkwAAjBY',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1877162-608-3',
  'REDIRECT_H2_STREAM_ID' => '3',
  '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/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/our-providers-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj5rkr4x6Ef3Wff6bvjkwAAjBY',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/our-providers-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794701742.1948120594024658203125,
  'REQUEST_TIME' => 1794701742,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

82! / 0

Colorado Springs Orthopaedic Group Providers