Accessibility Tools

Hip Surgery

Hip Service

Colorado Springs Orthopaedic Group

Your hips support your body and help you walk, move, exercise, and perform everyday activities. Hip pain can develop from an injury, overuse, arthritis, or other conditions and may gradually limit your mobility and quality of life.

CSOG provides comprehensive care for a wide range of hip conditions, from sports injuries and tendon problems to arthritis, fractures, and degenerative joint conditions. Treatment may include physical therapy, medications, injections, activity modification, minimally invasive procedures, or hip replacement when appropriate.

Our specialists focus on finding the underlying cause of your symptoms and determining the most appropriate treatment for your needs. Whether you require nonsurgical care or advanced surgical treatment, our goal is to relieve pain, improve mobility, and help you return to the activities you enjoy.

What is Hip Surgery?

Hip surgery is a surgical procedure for the treatment of a hip injury or hip condition. The procedure involves repairing diseased or damaged structures of the hip joint in order to eliminate pain and restore normal hip function.

The hip joint is one of the body's largest weight-bearing joints and is the point where the thighbone (femur) and pelvis (acetabulum) join. It is a ball-and-socket joint in which the head of the femur forms the ball, and the pelvic acetabulum forms the socket. The joint surface is covered by smooth articular cartilage that cushions and enables smooth movement of the joint. Stability of the hip joint is achieved by the labrum, ligaments, and tendons that encase the hip and support hip movements. Any damage to these structures may warrant a hip surgery.

What are the Indications for Hip Surgery?

Hip surgery is indicated when non-surgical treatment such as medications, injections, physical therapy, closed reduction and manipulation have been unsuccessful in treating hip conditions such as:

  • Arthritis: Degenerative joint condition that causes the cartilage, the tissue that cushions and protects the ends of bones in a joint, to wear off, causing painful rubbing of the bones
  • Femoroacetabular impingement (FAI): Friction in the hip joint from abnormal bony irregularities
  • Hip dislocation: Head of the femur moves out of the socket
  • Hip dysplasia: Congenital hip condition characterized by a shallow acetabulum
  • Labral tear: Tear or separation of the labrum, a cartilaginous ring that surrounds the socket and seals the hip joint
  • Avascular necrosis: Disrupted blood flow to the hip joint, causing death of bone tissue
  • Hip fracture: A break in the hip bone as a result of a high-energy trauma or bone weakness.

What Does the Procedure for Hip Surgery Involve?

Several types of hip surgeries can be performed based on your hip condition. Hip surgery is usually performed under general or local anesthesia either as an open surgery or as a minimally invasive arthroscopic procedure.

In an arthroscopic procedure, tiny incisions (portals), about a half-inch in length, are made around the hip joint area. Through one of the incisions, an arthroscope - a small flexible tube with a light and video camera at the end - is passed into the joint. The camera attached to the arthroscope displays the images of the inside of the joint on a monitor, which allows your surgeon to view the damage and carry out the required repair.

In an open surgery, a long incision of several centimeters is made over the hip joint. The underlying soft tissues are carefully moved aside to expose the treatment area. Special surgical tools are used to carry out the required repair around the joint. Once the repair is complete, the instruments are removed and the incisions are closed with stitches or small sterile bandage strips.

Some of the common hip surgeries include:

  • Hip labrum repair: This is a surgery employed for the treatment of a torn hip labrum. A hip labral tear is an injury to the labrum, the cartilage that surrounds the outside rim of your hip joint socket. The labrum helps to deepen the socket and provide stability to the joint. It also acts as a cushion and enables smooth movement of the joint. During hip labrum repair surgery, your surgeon repairs the torn tissue by sewing it back together or removes the torn piece all together, depending upon the cause and extent of the tear.
  • Hip labrum reconstruction: In some instances, where the hip labrum tear is severe and repair is not possible, your surgeon may perform a surgery called hip labrum reconstruction. In this surgery, a tissue graft is obtained from your own body (autograft) or a donor (allograft) and the graft is secured to the remaining part of the labrum utilizing durable stitching.
  • Surgery for snapping hip syndrome: Snapping hip syndrome is a condition in which you hear or feel a snapping sound in the hip when you swing your legs, run, walk or get up from a chair. The movement of muscles or tendons over a bony protrusion in the hip region or the presence of loose body fragments such as fragments of bone or cartilage in the joint space can give rise to the snapping sound. Common surgeries for snapping hip syndrome include:
    • Iliotibial band release: This procedure involves lengthening of the iliotibial band to decrease tension and hip snapping.
    • Iliopsoas tendon release: This procedure involves lengthening of the iliopsoas tendon to decrease muscle tension and hip clicking.
    • Arthroscopic hip debridement: This procedure involves making small incisions at the hip joint cavity and removing bone or cartilage fragments.
  • Femoral osteoplasty: This is a surgery to correct femoroacetabular impingement (FAI), a condition characterized by excessive friction in the hip joint from the presence of bony irregularities, which damages the articular cartilage (the smooth white surface of the ball or socket) or the labral tissue (the lining of the edge of the socket). During femoral osteoplasty surgery, your surgeon removes excess bone from the femoral neck to make enough room for free motion of the hip joint, as well as repair any labral tears or cartilage damage caused by impingement.
  • Periacetabular osteoplasty: This is a surgery to correct hip dysplasia. Hip dysplasia is a condition that is seen in infants and young children as a result of developmental problems in the hip joint. The femur (thigh bone) partially or completely slips out of the hip socket causing dislocation at the hip joint. During periacetabular osteoplasty surgery, your surgeon trims the hip socket (acetabulum) so that the femoral head can be repositioned in the pelvis, inserts metal screws into the bone to stabilize it in the new position, and smooths out any bone deformities that may be causing pain.
  • Surgery for avascular necrosis: Avascular necrosis, also called osteonecrosis, is a condition in which bone death occurs because of inadequate blood supply to it. Lack of blood flow may occur when there is a fracture in the bone or a joint dislocation that may damage nearby blood vessels. Avascular necrosis can be treated by one of the following methods:
    • Core decompression: During this procedure, a portion of the inner layer of the bone is removed to relieve the pressure inside the bone. This decreases the pain and allows the growth of new blood vessels; thereby, stimulating new bone growth.
    • Bone transplant: Healthy bone harvested from another part of your body is grafted into the affected area.
    • Bone reshaping (osteotomy): This procedure is performed in advanced stages and involves reshaping of the bone which is done to decrease the stress placed over the affected bone.
  • Total hip replacement: This is a surgery commonly employed for the treatment of hip joint arthritis or damage to the hip joint as a result of severe trauma or fracture. In this surgery, the damaged articulating parts of the hip joint are removed and replaced with artificial prostheses to restore normal hip function.

What Does Postoperative Care for Hip Surgery Involve?

In general, postoperative care instructions and recovery after hip surgery will involve the following:

  • You will be transferred to the recovery area where your nurse will closely observe you for any allergic/anesthetic reactions and monitor your vital signs as you recover.
  • You may notice some pain, swelling, and discomfort in the hip area. Pain and anti-inflammatory medications are provided as needed.
  • You will be placed on assistive devices such as crutches with instructions on restricted weight-bearing for a specified period of time. You are encouraged to walk with assistance as frequently as possible to prevent blood clots.
  • Keep the surgical site clean and dry. Instructions on surgical site care and bathing will be provided.
  • Refrain from smoking as it can negatively affect the healing process.
  • Refrain from strenuous activities for the first few months and lifting heavy weights for at least 6 months. Gradual increase in activities over a period of time is recommended.
  • An individualized physical therapy protocol will be designed to help strengthen hip muscles and optimize hip function.
  • You will be able to resume your normal activities in 3 to 4 weeks after surgery; however, you may have certain activity restrictions, and return to sports may take at least 6 months or longer.
  • A periodic follow-up appointment will be scheduled to monitor your progress.

What are the Risks and Complications of Hip Surgery?

Hip surgery is a relatively safe procedure; however, as with any surgery, some risks and complications may occur, such as the following:

  • Infection
  • Bleeding
  • Damage to nerves and vessels
  • Thromboembolism or blood clots
  • Hip instability
  • Joint stiffness
  • Leg length discrepancy
  • Dislocation
  • Re-rupture of the repaired tendon
  • Hardware failure
  • Graft failure
  • Need for additional surgery

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 Hip 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/hip/hip-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/hip/hip-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/hip/hip-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 = '14'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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 = '14' 
        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 = '14' 
            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
30Fellowship Trained & Board Certified Orthopedic Surgeond-alex-forrester-mdD. Alex Forrester, MD1d-alex-forrester-md-1784567112.pngMDDoctor000
32Fellowship Trained & Board Certified Orthopedic Surgeoneric-k-jepson-doEric K. Jepson, DO1eric-k-jepson-do-1784567040.pngMDDoctor000
29Fellowship Trained & Board Certified Orthopedic Surgeonmichael-feign-doMichael Feign, DO1michael-feign-do-1784567177.pngMDDoctor000
37Fellowship Trained & Board Certified Orthopedic Surgeonmichael-van-manen-doMichael Van Manen, DO1michael-van-manen-do-1784566704.pngMDDoctor000
26Fellowship Trained & Board Certified Orthopedic Surgeontyler-bron-mdTyler Bron, MD1tyler-bron-md-1784652250.pngMDDoctor000
63devin-pao-pa-cDevin Pao, PA-C2devin-pao-pa-c-1784569902.pngPAPhysician AssistantTyler Bron, MD26tyler-bron-md
42julia-beski-pa-cJulia Beski, PA-C2julia-beski-new-1791200195.jpgPAPhysician AssistantMichael Feign, DO29michael-feign-do
61robert-peterson-pa-cRobert Peterson, PA-C2robert-peterson-pa-c-1784570126.pngPAPhysician AssistantEric K. Jepson, DO32eric-k-jepson-do
53tyler-walker-pa-cTyler Walker, PA-C2tyler-walker-pa-c-1784570216.pngPAPhysician AssistantTyler Bron, MD26tyler-bron-md
59ellen-lopez-npEllen Lopez, NP3ellen-lopez-np-1784570191.pngNPNurse PractitionerTyler Bron, MD26tyler-bron-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
29michael-feign-doMichaelFeign, DOMichael Feign, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
32eric-k-jepson-doEric K.Jepson, DOEric K. Jepson, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
008
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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
009
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-orthopaedic-specialists-colorado-springs-co/
32eric-k-jepson-doEric K.Jepson, DOEric K. Jepson, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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 = '14'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()123
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 = '14' 
    OR id = '14' 
GROUP BY 
    id
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()123
012
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '14' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
446Revision Hip Surgery/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/141revision-hip-surgery1
447Femoroplasty/hip/femoroplasty-orthopaedic-specialists-colorado-springs-co/141femoroplasty1
448Hip Bursectomy/hip/hip-bursectomy-orthopaedic-specialists-colorado-springs-co/141hip-bursectomy1
449Ultrasound Guided Hip Injections/hip/ultrasound-guided-hip-injections-orthopaedic-specialists-colorado-springs-co/141ultrasound-guided-hip-injections1
450Nonsurgical Hip Treatments/hip/nonsurgical-hip-treatments-orthopaedic-specialists-colorado-springs-co/141nonsurgical-hip-treatments1
451Complex Hip Reconstruction Surgery/hip/complex-hip-reconstruction-surgery-orthopaedic-specialists-colorado-springs-co/141complex-hip-reconstruction-surgery1
452Posterior Hip Replacement/hip/posterior-hip-replacement-orthopaedic-specialists-colorado-springs-co/141posterior-hip-replacement1
453Hip Cartilage Repair/hip/hip-cartilage-repair-orthopaedic-specialists-colorado-springs-co/141hip-cartilage-repair1
454Hip Surgery/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/141hip-surgery1
455Core Muscle Repair/hip/core-muscle-repair-orthopaedic-specialists-colorado-springs-co/141core-muscle-repair1
456Outpatient Hip Replacement/hip/outpatient-hip-replacement-orthopaedic-specialists-colorado-springs-co/141outpatient-hip-replacement1
457Hip Resurfacing/hip/hip-resurfacing-orthopaedic-specialists-colorado-springs-co/141hip-resurfacing1
458Hip Labral Repair/hip/hip-labral-repair-orthopaedic-specialists-colorado-springs-co/141hip-labral-repair1
459Hip Preservation Surgery/hip/hip-preservation-surgery-orthopaedic-specialists-colorado-springs-co/141hip-preservation-surgery1
460Hip Fracture Surgery/hip/hip-fracture-surgery-orthopaedic-specialists-colorado-springs-co/141hip-fracture-surgery1
461Same Day Hip Replacement/hip/same-day-hip-replacement-orthopaedic-specialists-colorado-springs-co/141same-day-hip-replacement1
462Proximal Hamstring Repair/hip/proximal-hamstring-repair-orthopaedic-specialists-colorado-springs-co/141proximal-hamstring-repair1
463Physical Therapy for Hip/hip/physical-therapy-hip-orthopaedic-specialists-colorado-springs-co/141physical-therapy-for-hip1
464Hip Arthroscopy/hip/hip-arthroscopy-orthopaedic-specialists-colorado-springs-co/141hip-arthroscopy1
465Total Hip Replacement/hip/total-hip-replacement-orthopaedic-specialists-colorado-springs-co/141total-hip-replacement1
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()123
013
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '14' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
484Osteoarthritis of the Hip/hip/osteoarthritis-hip-orthopaedic-specialists-colorado-springs-co/142osteoarthritis-of-the-hip1
485Inflammatory Arthritis of the Hip/hip/inflammatory-arthritis-hip-orthopaedic-specialists-colorado-springs-co/142inflammatory-arthritis-of-the-hip1
486Hip Injury/hip/hip-injury-orthopaedic-specialists-colorado-springs-co/142hip-injury1
487Hip Pain/hip/hip-pain-orthopaedic-specialists-colorado-springs-co/142hip-pain1
488Hip Fracture/hip/hip-fracture-orthopaedic-specialists-colorado-springs-co/142hip-fracture1
489Pelvic Fractures/hip/pelvic-fractures-orthopaedic-specialists-colorado-springs-co/142pelvic-fractures1
490Hip Bursitis/hip/hip-bursitis-orthopaedic-specialists-colorado-springs-co/142hip-bursitis1
491Hip Instability/hip/hip-instability-orthopaedic-specialists-colorado-springs-co/142hip-instability1
492Femoroacetabular Impingement/hip/femoroacetabular-impingement-orthopaedic-specialists-colorado-springs-co/142femoroacetabular-impingement1
493Hip Dislocation/hip/hip-dislocation-orthopaedic-specialists-colorado-springs-co/142hip-dislocation1
494Hip Labral Tear/hip/hip-labral-tear-orthopaedic-specialists-colorado-springs-co/142hip-labral-tear1
495Hip Ligament Injuries/hip/hip-ligament-injuries-orthopaedic-specialists-colorado-springs-co/142hip-ligament-injuries1
496Gluteus Medius Tear/hip/gluteus-medius-tear-orthopaedic-specialists-colorado-springs-co/142gluteus-medius-tear1
497Proximal Femoral Fracture/hip/proximal-femoral-fracture-orthopaedic-specialists-colorado-springs-co/142proximal-femoral-fracture1
498Stress Fractures of the Hip/hip/stress-fractures-hip-orthopaedic-specialists-colorado-springs-co/142stress-fractures-of-the-hip1
499Post-Traumatic Hip Arthritis/hip/post-traumatic-hip-arthritis-orthopaedic-specialists-colorado-springs-co/142post-traumatic-hip-arthritis1
500Hip Adductor Injuries/hip/hip-adductor-injuries-orthopaedic-specialists-colorado-springs-co/142hip-adductor-injuries1
501Acetabular Fracture/hip/acetabular-fracture-orthopaedic-specialists-colorado-springs-co/142acetabular-fracture1
502Hip Muscle Strain/hip/hip-muscle-strain-orthopaedic-specialists-colorado-springs-co/142hip-muscle-strain1
503Hip Tendonitis/hip/hip-tendonitis-orthopaedic-specialists-colorado-springs-co/142hip-tendonitis1
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()123
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' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/hip/hip-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-459',
  'H2_STREAM_ID' => '459',
  '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/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-fwC7ojUlkocvPDucMwABDwQ',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-459',
  'REDIRECT_H2_STREAM_ID' => '459',
  '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/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-fwC7ojUlkocvPDucMwABDwQ',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702976.0640659332275390625,
  'REQUEST_TIME' => 1794702976,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
13! / 0