Accessibility Tools

Arthroscopic Surgery

Sports Medicine Service

Colorado Springs Orthopaedic Group

Sports injuries can happen to competitive athletes, active adults, weekend athletes, and anyone who enjoys staying physically active. Whether caused by an acute injury or repetitive stress, these problems can affect your performance and keep you from doing the activities you enjoy.

CSOG provides comprehensive sports medicine care for a wide range of injuries and conditions affecting the joints, muscles, tendons, and ligaments. Our specialists emphasize accurate diagnosis and individualized treatment, with options that may include rehabilitation, physical therapy, injections, minimally invasive procedures, and surgery when necessary.

Our approach is focused not only on treating the immediate injury but also on helping you safely regain strength, mobility, and confidence. The goal is to help you return to your sport or activity at the appropriate stage of recovery.

What is Arthroscopic Surgery?

Arthroscopic surgery, also known as arthroscopy, is a surgical procedure to visualize, diagnose, and treat problems inside a joint using a specialized instrument known as an arthroscope.

An arthroscope is a flexible fiberoptic tube that contains a small lens or camera and a lighting system to magnify and illuminate structures inside a joint. The camera attached to the arthroscope shows an image of the joint on a television screen allowing the surgeon to examine the affected joint or areas such as cartilage, ligaments, and tendons, and perform the repair.

Different Types of Arthroscopic Surgery

Arthroscopic surgery can be performed on any joint. Shoulder and knee arthroscopy are the most common arthroscopic procedures conducted for repairing meniscus and cartilage problems and fixing rotator cuff tears respectively. Some of the common types of arthroscopic surgery include:

  • Shoulder arthroscopy
  • Knee arthroscopy
  • Ankle arthroscopy
  • Hip arthroscopy
  • Wrist arthroscopy
  • Elbow arthroscopy

Indications for Arthroscopic Surgery

In general, arthroscopic surgery is conducted to diagnose and treat a variety of conditions. Arthroscopic surgery is commonly indicated for:

  • Articular cartilage defects and injuries
  • Joint debridement and washout for osteoarthritis
  • Removal of loose bodies
  • Synovectomy
  • Meniscal tears
  • Anterior cruciate ligament (ACL) tears
  • Posterior cruciate ligament (PCL) tears
  • Arthroscopic-assisted fixation of tibial plateau fractures
  • Evaluation of joints prior to joint replacement

Preparation for Arthroscopic Surgery

Arthroscopic surgery preparation depends on the joint being examined or repaired by your surgeon. However, in general, you are required to:

  • Avoid taking certain medications or supplements that may increase the risk of bleeding
  • Inform your doctor if you are allergic to any medications or anesthesia
  • Avoid consuming liquids or solid foods 6 to 8 hours before surgery
  • Wear comfortable clothing to get on and off easily
  • Bring assistive devices, such as a walker, cane, or crutches
  • Arrange for a ride as you will not be able to drive back yourself

Arthroscopic Surgery Procedure

The surgery is performed under general or local anesthesia. After adequately sterilizing the surgical area, your surgeon makes a few small keyhole incisions through which the arthroscope and tiny specialized instruments are inserted. The joints are irrigated with water to clear debris and aid in visibility. The camera attached to the tip of the arthroscope allows the doctor to view the structures inside the joint through a television screen, and the damaged structures are repaired. The instruments and arthroscope are then withdrawn, and the surgical incisions are closed with sterile dressings or sutures.

Postoperative Care of Arthroscopic Surgery

Before being discharged, your doctor or nurse will give you appropriate postop instructions, such as:

  • How to care your incisions and dressing
  • Exercises you should do
  • What activities you must avoid
  • Use of assistive devices like a sling, splint, or crutches
  • Use of pain medications
  • Rehabilitation program for a quicker recovery
  • Follow-up visit to remove dressings or sutures and monitor your overall progress

Risks and Complications of Arthroscopic Surgery

The risks and complications of an arthroscopic procedure are minimal and occur in less than one percent of all arthroscopic surgeries. Some of the possible risks and complications of arthroscopic surgery include:

  • Infection
  • Swelling or bleeding
  • Blood clots
  • Damage to nerves or blood vessels
  • Instrument breakage
  • Anesthetic problems

Benefits of Arthroscopic Surgery Over Traditional Open Surgery

Some of the benefits of arthroscopic surgery over traditional open surgery include:

  • Can usually be carried out as an outpatient procedure
  • Swelling is substantially reduced due to minimal incisions
  • Pain is substantially reduced due to minimal manipulation of healthy tissue
  • Risk of infection is less due to the minimally invasive approach
  • Risk of complications associated with blood loss is notably minimal
  • Shorter hospital stay and much lesser recovery time
  • Very minimal incisional scarring
  • Reduced surgical risk as arthroscopic surgery is a minimally invasive procedure
  • Usually more successful than open joint procedures
  • Both diagnosis and surgery can be carried out in one approach
  • Use of tiny instruments in arthroscopy aids in minimal damage to surrounding tissues compared to large-sized surgical devices

For more information about our services or to schedule an appointment, call us at or click here to request an appointment online. We'll respond to you as soon as possible.

How Can You Reach CSOG Sports Medicine Center
  • Send a Referral
  • Send Medical Records
  • Additional Inquires
Colorado Springs Locations
Orthopaedic Care Across Colorado Springs

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

4110 Briargate Parkway
Suite 300
Colorado Springs, CO 80920

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

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

6140 Tutt Blvd
Suite 110
Colorado Springs, CO 80923

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

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"
FileFunctionLine
/home/csogy/public_html/database/Zebra_Database.phpquery()3907
/home/csogy/public_html/helpers/functions.phpset_charset()42
/home/csogy/public_html/models/YpoDatabase.phpgetConnection()22
/home/csogy/public_html/models/Provider.php__construct()27
/home/csogy/public_html/configs/common.php__construct()182
/home/csogy/public_html/common/common.phprequire_once()5
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_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/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/' 
        OR T.is_global = 1
    ) 
ORDER BY 
    T.is_global ASC, 
    T.id DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLETALL333.33Using where; Using temporary; Using filesort
1SIMPLEPUALL3100.00Using where; Distinct; Using join buffer (hash join)
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/PageAlert.phprawQuery()67
/home/csogy/public_html/models/PageAlert.phpgetCurrentPageAlerts()76
/home/csogy/public_html/configs/common.phpgetCurrentPageAlertsGrouped()185
/home/csogy/public_html/common/common.phprequire_once()5
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()3
003
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '17'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
170Sports Medicinesports-medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:25:022026-07-15 18:25:02
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesconstPRIMARYPRIMARY4const1100.00
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Speciality.phprawQuerySingle()50
/home/csogy/public_html/includes/speacialist-list.phpgetRecord()3
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
004
(
    SELECT 
        D.id, 
        D.designation, 
        D.slug, 
        D.short_title, 
        D.provider_type, 
        D.photo, 
        PT.sh_name, 
        PT.type AS p_type, 
        0 as dr_short_title, 
        0 as dr_id, 
        0 as dr_slug 
    FROM 
        cs_providers D 
        INNER JOIN cs_provider_specialties PS ON PS.provider_id = D.id 
        INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, D.provider_type) > 0 
    WHERE 
        PS.specialty_id = '17' 
        AND D.status = 1 
    GROUP BY 
        D.id
) 
UNION 
    (
        SELECT 
            A.id, 
            A.designation, 
            A.slug, 
            A.short_title, 
            A.provider_type, 
            A.photo, 
            PT.sh_name, 
            PT.type AS p_type, 
            D.short_title AS dr_short_title, 
            D.id as dr_id, 
            D.slug as dr_slug 
        FROM 
            cs_provider_specialties PS 
            INNER JOIN cs_providers D ON D.id = PS.provider_id 
            INNER JOIN cs_provider_assistant PA ON PA.doctor_id = D.id 
            INNER JOIN cs_providers A ON A.id = PA.assistant_id 
            INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, A.provider_type) > 0 
        WHERE 
            PS.specialty_id = '17' 
            AND FIND_IN_SET(1, D.provider_type) > 0 
            AND D.status = 1 
            AND A.status = 1 
        GROUP BY 
            A.id
    ) 
ORDER BY 
    provider_type, 
    short_title
iddesignationslugshort_titleprovider_typephotosh_namep_typedr_short_titledr_iddr_slug
121Fellowship Trained & Board Certified Orthopedic Surgeonbenjamin-meyer-doBenjamin Meyer, DO1benjamin-meyer-do-1787569723.pngMDDoctor000
39Fellowship Trained & Board Certified Orthopedic Surgeoncraig-a-yager-mdCraig A. Yager, MD1craig-a-yager-md-1784566587.pngMDDoctor000
24Fellowship Trained and Board Certified Orthopedic Surgeondouglas-adams-mdDouglas Adams, MD1douglas-adams-md-1784632621.pngMDDoctor000
31Fellowship Trained & Board Certified Orthopedic Surgeonjamie-l-friedman-mdJamie L. Friedman, MD1jamie-l-friedman-md-1784567065.pngMDDoctor000
33Fellowship Trained & Board Certified Orthopedic Surgeonjohn-c-redfern-mdJohn C. Redfern, MD1john-c-redfern-md-1784566994.pngMDDoctor000
58kristen-reiss-pa-cKristen Reiss, PA-C2kristen-reiss-pa-c-1784570323.pngPAPhysician AssistantCraig A. Yager, MD39craig-a-yager-md
41mattie-batchelder-pa-cMattie Batchelder, PA-C2mattie-batchelder-pa-c-1784569975.pngPAPhysician AssistantDouglas Adams, MD24douglas-adams-md
49nicole-derby-pa-cNicole Derby, PA-C2nicole-derby-pa-c-1784569924.pngPAPhysician AssistantJamie L. Friedman, MD31jamie-l-friedman-md
54phillip-falender-pa-cPhillip Falender, PA-C2phillip-falender-1791190973.jpgPAPhysician AssistantJohn C. Redfern, MD33john-c-redfern-md
126rebecca-debalski-pa-cRebecca DeBalski, PA-C2rebecca-debalski-pac-1790826550.jpgPAPhysician AssistantCraig A. Yager, MD39craig-a-yager-md
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPTALL6100.00Using temporary
1PRIMARYPSALL8010.00Using where; Using join buffer (hash join)
1PRIMARYDeq_refPRIMARYPRIMARY4csogy_csog_db.PS.provider_id110.00Using where
2UNIONPTALL6100.00Using temporary
2UNIONPSALL8010.00Using where; Using join buffer (hash join)
2UNIONDeq_refPRIMARYPRIMARY4csogy_csog_db.PS.provider_id110.00Using where
2UNIONPAALL3510.00Using where; Using join buffer (hash join)
2UNIONAeq_refPRIMARYPRIMARY4csogy_csog_db.PA.assistant_id110.00Using where
3UNION RESULT<union1,2>ALLUsing temporary; Using filesort
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()529
/home/csogy/public_html/includes/speacialist-list.phpgetSpecalityListDrWithAssitents()4
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
005
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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
39craig-a-yager-mdCraigYager, MDCraig A. Yager, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
006
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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
24douglas-adams-mdDouglasAdams, MDDouglas Adams, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
007
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
31jamie-l-friedman-mdJamie L.Friedman, MDJamie L. Friedman, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
008
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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
33john-c-redfern-mdJohn C.Redfern, MDJohn C. Redfern, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
009
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
39craig-a-yager-mdCraigYager, MDCraig A. Yager, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/sports-speacialist.phprequire_once()1
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()125
010
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '17'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
170Sports Medicinesports-medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:25:022026-07-15 18:25:02
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesconstPRIMARYPRIMARY4const1100.00
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Speciality.phprawQuerySingle()50
/home/csogy/public_html/includes/specialty-sidebar.phpgetRecord()2
/home/csogy/public_html/includes/sports-sidebar.phprequire_once()20
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()128
011
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    parent_id = '17' 
    OR id = '17' 
GROUP BY 
    id
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
170Sports Medicinesports-medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:25:022026-07-15 18:25:02
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesindex_mergePRIMARY,idx_parentidx_parent,PRIMARY5,42100.00Using union(idx_parent,PRIMARY); Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()60
/home/csogy/public_html/includes/specialty-sidebar.phpgetSubSplaityList()14
/home/csogy/public_html/includes/sports-sidebar.phprequire_once()20
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()128
012
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '17' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
718Arthritis Surgery/sports-medicine/arthritis-surgery-orthopaedic-specialists-colorado-springs-co/171arthritis-surgery1
719Arthroscopic Surgery/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/171arthroscopic-surgery1
720Robotic-Assisted Joint Replacement/sports-medicine/robotic-assisted-joint-replacement-orthopaedic-specialists-colorado-springs-co/171robotic-assisted-joint-replacement1
721Fracture Surgery/sports-medicine/fracture-surgery-orthopaedic-specialists-colorado-springs-co/171fracture-surgery1
722Fracture Care/sports-medicine/fracture-care-orthopaedic-specialists-colorado-springs-co/171fracture-care1
723Corticosteroid Injections/sports-medicine/corticosteroid-injections-orthopaedic-specialists-colorado-springs-co/171corticosteroid-injections1
724Joint Preservation Surgery/sports-medicine/joint-preservation-surgery-orthopaedic-specialists-colorado-springs-co/171joint-preservation-surgery1
725Ligament Preservation/Repair/sports-medicine/ligament-preservation-repair-orthopaedic-specialists-colorado-springs-co/171ligament-preservation-repair1
726Sports Physical/sports-medicine/sports-physical-orthopaedic-specialists-colorado-springs-co/171sports-physical1
727Tendon Repair Surgery/sports-medicine/tendon-repair-surgery-orthopaedic-specialists-colorado-springs-co/171tendon-repair-surgery1
728Joint Replacement/sports-medicine/joint-replacement-orthopaedic-specialists-colorado-springs-co/171joint-replacement1
729Cartilage Transplantation/sports-medicine/cartilage-transplantation-orthopaedic-specialists-colorado-springs-co/171cartilage-transplantation1
730Cartilage Preservation Techniques/sports-medicine/cartilage-preservation-techniques-orthopaedic-specialists-colorado-springs-co/171cartilage-preservation-techniques1
731Outpatient Joint Replacement/sports-medicine/outpatient-joint-replacement-orthopaedic-specialists-colorado-springs-co/171outpatient-joint-replacement1
732Ligament Reconstruction/sports-medicine/ligament-reconstruction-orthopaedic-specialists-colorado-springs-co/171ligament-reconstruction1
733Joint Reconstruction Surgery/sports-medicine/joint-reconstruction-surgery-orthopaedic-specialists-colorado-springs-co/171joint-reconstruction-surgery1
734Bone Scan/sports-medicine/bone-scan-orthopaedic-specialists-colorado-springs-co/171bone-scan1
735Cartilage Restoration/sports-medicine/cartilage-restoration-orthopaedic-specialists-colorado-springs-co/171cartilage-restoration1
736Ultrasound Guided Joint Aspiration/sports-medicine/ultrasound-guided-joint-aspiration-orthopaedic-specialists-colorado-springs-co/171ultrasound-guided-joint-aspiration1
737Proximal Hamstring Repair/hip/proximal-hamstring-repair-orthopaedic-specialists-colorado-springs-co/171proximal-hamstring-repair1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialties_condestions_proceduresALL8461.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()36
/home/csogy/public_html/includes/specialty-sidebar.phpgetCondestion()26
/home/csogy/public_html/includes/sports-sidebar.phprequire_once()20
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()128
013
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '17' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
750Arthritis/sports-medicine/arthritis-orthopaedic-specialists-colorado-springs-co/172arthritis1
751Post-traumatic Arthritis/sports-medicine/post-traumatic-arthritis-orthopaedic-specialists-colorado-springs-co/172post-traumatic-arthritis1
752Inflammatory Arthritis/sports-medicine/inflammatory-arthritis-orthopaedic-specialists-colorado-springs-co/172inflammatory-arthritis1
753Joint Injuries/sports-medicine/joint-injuries-orthopaedic-specialists-colorado-springs-co/172joint-injuries1
754Tendon Injuries/sports-medicine/tendon-injuries-orthopaedic-specialists-colorado-springs-co/172tendon-injuries1
755Bursitis/sports-medicine/bursitis-orthopaedic-specialists-colorado-springs-co/172bursitis1
756Ligament Injuries/sports-medicine/ligament-injuries-orthopaedic-specialists-colorado-springs-co/172ligament-injuries1
757Workplace Injuries/sports-medicine/workplace-injuries-orthopaedic-specialists-colorado-springs-co/172workplace-injuries1
758Musculoskeletal Injuries/sports-medicine/musculoskeletal-injuries-orthopaedic-specialists-colorado-springs-co/172musculoskeletal-injuries1
759Muscle Spasms (Cramps)/sports-medicine/muscle-spasms-cramps-orthopaedic-specialists-colorado-springs-co/172muscle-spasms-cramps1
760Concussions/sports-medicine/concussions-orthopaedic-specialists-colorado-springs-co/172concussions1
761Slip and Fall Injuries/sports-medicine/slip-fall-injuries-orthopaedic-specialists-colorado-springs-co/172slip-and-fall-injuries1
762Tendonitis/sports-medicine/tendonitis-orthopaedic-specialists-colorado-springs-co/172tendonitis1
763Osteoporosis/sports-medicine/osteoporosis-orthopaedic-specialists-colorado-springs-co/172osteoporosis1
764Osteoporosis Pain/sports-medicine/osteoporosis-pain-orthopaedic-specialists-colorado-springs-co/172osteoporosis-pain1
765Complex Fractures/sports-medicine/complex-fractures-orthopaedic-specialists-colorado-springs-co/172complex-fractures1
766Osteoarthritis/sports-medicine/osteoarthritis-orthopaedic-specialists-colorado-springs-co/172osteoarthritis1
767Musculoskeletal Tumors/sports-medicine/musculoskeletal-tumors-orthopaedic-specialists-colorado-springs-co/172musculoskeletal-tumors1
768Overuse Injuries/sports-medicine/overuse-injuries-orthopaedic-specialists-colorado-springs-co/172overuse-injuries1
769Muscle and Joint Pain/sports-medicine/muscle-joint-pain-orthopaedic-specialists-colorado-springs-co/172muscle-and-joint-pain1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialties_condestions_proceduresALL8461.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()36
/home/csogy/public_html/includes/specialty-sidebar.phpgetCondestion()46
/home/csogy/public_html/includes/sports-sidebar.phprequire_once()20
/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()128
001
$_REQUEST
array (
)
001
$_POST
array (
)
001
$_GET
array (
)
001
$_SESSION
array (
)
001
$_COOKIE
array (
  'PHPSESSID' => 'adbf53d4138883daf6f46484e5767368',
)
001
$_FILES
array (
)
001
$_SERVER
array (
  'USER' => 'csogy',
  'HOME' => '/home/csogy',
  'SCRIPT_NAME' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'SERVER_ADMIN' => 'webmaster@csog.ypo.pw',
  'CONTEXT_DOCUMENT_ROOT' => '/home/csogy/public_html',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'https',
  'DOCUMENT_ROOT' => '/home/csogy/public_html',
  'REMOTE_ADDR' => '216.73.216.171',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '172.31.81.87',
  'SERVER_NAME' => 'csog.ypo.pw',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin',
  'HTTP_X_HTTPS' => '1',
  'HTTP_HOST' => 'csog.ypo.pw',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_COOKIE' => 'PHPSESSID=adbf53d4138883daf6f46484e5767368',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'proxy-nokeepalive' => '1',
  'H2_STREAM_TAG' => '1922844-609-1807',
  'H2_STREAM_ID' => '1807',
  '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/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-vQC7ojUlkocvPDue3AABDw4',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-1807',
  'REDIRECT_H2_STREAM_ID' => '1807',
  '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/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-vQC7ojUlkocvPDue3AABDw4',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794703037.53127288818359375,
  'REQUEST_TIME' => 1794703037,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
13! / 0