Accessibility Tools

Lumbar Microdecompression

Spine Service

Colorado Springs Orthopaedic Group

Spinal conditions can affect your neck, back, movement, and overall quality of life. Pain, stiffness, numbness, or weakness can make it difficult to work, exercise, sleep, or perform everyday activities.

CSOG provides comprehensive care for a wide range of conditions affecting the cervical, thoracic, and lumbar spine. Our specialists use a conservative-first approach whenever appropriate, with treatment options that may include physical therapy, medications, injections, and other nonsurgical treatments. When surgery is necessary, advanced surgical techniques may provide another option.

Your care begins with a thorough evaluation to understand the source of your symptoms and how they are affecting you. We then develop a treatment plan based on your condition, goals, and individual needs.

What is Lumbar Microdecompression?

Lumbar microdecompression, also known as lumbar microdiscectomy, is a minimally invasive surgical procedure to relieve pressure from pinched nerves in the lower back or lumbar region using microsurgical techniques. The procedure involves the removal of a small section of the bone and/or disc material pressing on the spinal cord and/or nerve roots in the lumbar spine to relieve painful symptoms.

Herniated lumbar disc and spinal stenosis are the two most common reasons for which lumbar microdecompression is recommended.

A herniated disc, common in the lower back (lumbar spine) occurs when the inner gelatinous substance of the disc escapes through a tear in the outer, fibrous ring (annulus fibrosis). This may compress the spinal cord or the surrounding nerves, resulting in pain, sensory changes, or weakness in the lower extremities.

Spinal Stenosis involves the narrowing of the spinal canal due to arthritic changes in the facet joints and intervertebral discs. This causes enlargement of the joint leading to pressure on the spinal nerves causing symptoms of back pain or radiating pain into the hips, buttocks, or legs, numbness or muscle weakness, and tingling sensations in the back and lower extremities.

Anatomy of the Lumbar Spine

The spine or vertebral column consists of 33 vertebral bones stacked one on top of the other, with cushioning discs present between each vertebra. A cylindrical bundle of nerve fibers called the spinal cord passes through the entire vertebral column and branches out to various parts of the body. The lumbar spine in the lower back is composed of 5 vertebrae numbered L1–L5. Towards the front of each vertebra is a cylindrical block of bone called the vertebral body. Spongy vertebral discs are present between the vertebral bodies providing support and enabling movement. Damage or degeneration of the vertebral bodies or discs can lead to nerve compression causing pain, weakness, or numbness.

Indication for Lumbar Microdecompression

Some of the indications for lumbar microdecompression include:

  • Herniated lumbar disc
  • Spinal stenosis
  • Spinal injury or spinal tumors
  • Slipped disc and sciatica
  • Degenerative disc disease
  • Metastatic spinal cord compression
  • Failure of conservative treatments such as medications or physical therapy to relieve symptoms

Preparation for Lumbar Microdecompression

Preoperative preparation for lumbar microdecompression surgery will involve the following steps:

  • A thorough examination by your doctor is performed to check for any medical issues that need to be addressed prior to surgery.
  • Depending on your medical history, social history, and age, you may need to undergo tests such as blood work and imaging to help detect any abnormalities that could threaten the safety of the procedure.
  • You will be asked if you have allergies to medications, anesthesia, or latex.
  • You should inform your doctor of any medications, vitamins, or supplements that you are taking.
  • You should refrain from medications or supplements such as blood thinners, aspirin, or anti-inflammatory medicines for 1 to 2 weeks prior to surgery.
  • You should refrain from alcohol or tobacco at least a week before and 2 weeks after surgery to prevent increased risk of infection, slower wound healing, and bleeding problems.
  • You should not consume any solids or liquids at least 8 hours prior to surgery.
  • You will be placed on a special diet prior to surgery and laxatives may be used to clean out your bowel.
  • You may be instructed to shower with an antibacterial soap the night prior to surgery to help lower your risk of infection after surgery.
  • Arrange for someone to drive you home as you will not be able to drive yourself after surgery.
  • A written consent will be obtained from you after the surgical procedure has been explained in detail.

Procedure for Lumbar Microdecompression

A lumbar microdecompression is performed under general anesthesia. During the surgery, you will be lying on your stomach. An X-ray is taken to determine the exact location of the herniated disc. Your surgeon will make a small incision in the midline over your lower back. Through this incision, a series of progressively larger tubes are placed and positioned over the herniated disc. The affected nerve root is then identified. Your surgeon removes a small portion of the bony structure or disc material that is pressing on the spinal nerve using microsurgical techniques. The incisions are closed with absorbable sutures and covered with a dressing.

Postoperative Care and Recovery

In general, postoperative care instructions and recovery after lumbar microdecompression will involve the following steps:

  • 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.
  • Most patients can go home the same day. However, some may need to stay in the hospital for a day or two before discharge to home.
  • You may experience pain, inflammation, and discomfort in the operated area. Pain and anti-inflammatory medications are provided as needed.
  • Application of cold and heat therapy on the low back area is also recommended to reduce inflammation and pain.
  • Walking and moving around in bed is strongly encouraged to prevent the risk of blood clots.
  • Antibiotics are prescribed as needed to address the risk of surgery-related infection.
  • Your diet is slowly advanced post surgery. You will start with clear liquids, then progress to having normal solid foods, as tolerated.
  • Instructions on surgical site care and bathing will be provided.
  • Eating a high-calcium and low-fat diet is strongly recommended to promote healing and a faster recovery.
  • Avoid lifting, bending, or twisting your back for the first 6 weeks. Do not lift anything heavier than 5 pounds for the first 2 weeks. Refrain from any strenuous activities such as housework, yard work, or sex for at least a month.
  • Refrain from smoking as it inhibits bone growth and delays healing.
  • A physical therapy protocol is recommended to help strengthen low back, pelvic, and leg muscles and optimize their function. Walking is a good exercise and is strongly recommended to improve your endurance.
  • Refrain from driving until you are fully fit and receive your doctor’s consent.
  • You will be able to resume your normal activities in 2 to 3 weeks but may have certain activity restrictions.
  • Complete recovery and return to work vary from patient to patient as it is related to a patient’s age, overall health status, and the type of work one does.
  • A periodic follow-up appointment will be scheduled to monitor your progress.

Benefits of Lumbar Microdecompression

Some of the key benefits of lumbar microdecompression over traditional open decompression technique include:

  • Less disruption of muscle and soft tissues
  • Faster recovery time
  • Shorter hospital stay
  • Minimal post-operative pain and discomfort
  • Decreased blood loss
  • Minimal risk of post-operative infection
  • Smaller incision and minimal scar formation
  • Fewer risks of complications

Risks and Complications

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

  • Infection
  • Blood loss
  • Blood clots or deep vein thrombosis
  • Anesthetic/allergic reactions
  • Injury to nerves and vessels
  • Persistent pain
  • Recurrent stenosis
  • Spinal fluid leakage
  • Bowel or bladder problems

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 Spine 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/spine/lumbar-microdecompression-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/spine/lumbar-microdecompression-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/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()3
003
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '13'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
130Spinespine/spine-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:57:402026-07-30 20:06:22
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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
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 = '13' 
        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 = '13' 
            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
125Fellowship Trained & Board Eligible Orthopedic Surgeonbrendan-mitchell-mdBrendan Mitchell, MD1dr-brendan-mitchell-1790581119.jpgMDDoctor000
124Fellowship Trained & Board Certified Physicianchristopher-malinky-mdChristopher Malinky, MD1dr-malinky-1789030532.pngMDDoctor000
35Fellowship Trained & Board Certified Orthopedic Surgeonpaul-stanton-doPaul Stanton, DO1paul-stanton-do-1784566764.pngMDDoctor000
36Fellowship Trained & Board Certified Orthopedic Surgeonroger-d-sung-mdRoger D. Sung, MD1roger-d-sung-md-1784566737.pngMDDoctor000
43christian-birky-pa-cChristian Birky, PA-C2christian-birky-pa-c-1784570280.pngPAPhysician AssistantRoger D. Sung, MD36roger-d-sung-md
130heidi-bennett-pa-cHeidi Bennett, PA-C2hiedi-bennett-pac-1790581352.jpgPAPhysician AssistantChristopher Malinky, MD124christopher-malinky-md
57millie-livingston-pa-cMillie Livingston, PA-C2millie-livingson-pa-c-1784570343.pngPAPhysician AssistantRoger D. Sung, MD36roger-d-sung-md
48jenielle-daugherty-npJenielle Daugherty, NP3jenielle-daugherty-np-1784570437.pngNPNurse PractitionerPaul Stanton, DO35paul-stanton-do
60taylor-pinto-npTaylor Pinto, NP3taylor-pinto-np-1784570003.pngNPNurse PractitionerPaul Stanton, DO35paul-stanton-do
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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
36roger-d-sung-mdRoger D.Sung, MDRoger D. Sung, MDSpine/spine-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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
124christopher-malinky-mdChristopherMalinky, MDChristopher Malinky, MDPain Management/pain-management-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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
007
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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
36roger-d-sung-mdRoger D.Sung, MDRoger D. Sung, MDSpine/spine-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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
35paul-stanton-doPaulStanton, DOPaul Stanton, DOSpine/spine-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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
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 = '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
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
35paul-stanton-doPaulStanton, DOPaul Stanton, DOSpine/spine-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/spine-speacialist.phprequire_once()1
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()132
010
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '13'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
130Spinespine/spine-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:57:402026-07-30 20:06:22
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
011
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    parent_id = '13' 
    OR id = '13' 
GROUP BY 
    id
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
130Spinespine/spine-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:57:402026-07-30 20:06:22
2513Generalgeneral012026-07-15 18:37:012026-07-15 18:37:01
2613Cervicalcervical012026-07-15 18:37:292026-07-15 18:37:29
2713Thoracicthoracic012026-07-15 18:37:562026-07-15 18:37:56
3513Image Guided Surgery (Stealth, X-Vision)image-guided-surgery-stealth-x-vision012026-08-06 12:22:482026-08-07 13:49:20
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesindex_mergePRIMARY,idx_parentidx_parent,PRIMARY5,45100.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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
012
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '13' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
835Minimally Invasive Spine Reconstruction131minimally-invasive-spine-reconstruction1
833Lumbar Spine Surgery131lumbar-spine-surgery1
832Cervical Spine Surgery131cervical-spine-surgery1
837Lumbar Disk Surgery131lumbar-disk-surgery1
838Cervical Disk Replacement131cervical-disk-replacement1
839XLIF/Lateral Spine Surgery131xlif-lateral-spine-surgery1
840Anterior Spine Surgery131anterior-spine-surgery1
841Sacroiliac Joint (SI-Joint) Surgery131sacroiliac-joint-si-joint-surgery1
842Lateral Spine Surgery131lateral-spine-surgery1
843Minimally invasive SI Joint Fusion131minimally-invasive-si-joint-fusion1
844Spine Surgery with Local or Spinal Anesthesia131spine-surgery-with-local-or-spinal-anesthesia1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
013
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '13' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
834Spine Truama132spine-truama1
836Adult Spinal Deformity132adult-spinal-deformity1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
014
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '25' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
289Spinal Fusion/spine/spinal-fusion-orthopaedic-specialists-colorado-springs-co/251spinal-fusion1
290Spinal Decompression/spine/spinal-decompression-orthopaedic-specialists-colorado-springs-co/251spinal-decompression1
291Minimally Invasive Spine Surgery/spine/minimally-invasive-spine-surgery-orthopaedic-specialists-colorado-springs-co/251minimally-invasive-spine-surgery1
292Computer-Assisted Spine Surgery/spine/computer-assisted-spine-surgery-orthopaedic-specialists-colorado-springs-co/251computer-assisted-spine-surgery1
293Vertebroplasty/spine/vertebroplasty-orthopaedic-specialists-colorado-springs-co/251vertebroplasty1
294Motion Preservation Surgery/spine/motion-preservation-surgery-orthopaedic-specialists-colorado-springs-co/251motion-preservation-surgery1
295Degenerative Spine Surgery/spine/degenerative-spine-surgery-orthopaedic-specialists-colorado-springs-co/251degenerative-spine-surgery1
296Minimally Invasive Sacroiliac Joint Fusion/spine/minimally-invasive-sacroiliac-joint-fusion-orthopaedic-specialists-colorado-springs-co/251minimally-invasive-sacroiliac-joint-fusion1
297Laminectomy/spine/laminectomy-orthopaedic-specialists-colorado-springs-co/251laminectomy1
298Kyphoplasty/spine/kyphoplasty-orthopaedic-specialists-colorado-springs-co/251kyphoplasty1
299Spine Trauma Surgery/spine/spine-trauma-surgery-orthopaedic-specialists-colorado-springs-co/251spine-trauma-surgery1
300Foraminoplasty/spine/foraminoplasty-orthopaedic-specialists-colorado-springs-co/251foraminoplasty1
301Scoliosis Surgery/spine/scoliosis-surgery-orthopaedic-specialists-colorado-springs-co/251scoliosis-surgery1
302Kyphoplasty and Vertebroplasty/spine/kyphoplasty-vertebroplasty-orthopaedic-specialists-colorado-springs-co/251kyphoplasty-and-vertebroplasty1
303Microdiscectomy/spine/microdiscectomy-orthopaedic-specialists-colorado-springs-co/251microdiscectomy1
304Posterior Scoliosis Surgery/spine/posterior-scoliosis-surgery-orthopaedic-specialists-colorado-springs-co/251posterior-scoliosis-surgery1
305Spinal Cord Stimulator/spine/spinal-cord-stimulator-orthopaedic-specialists-colorado-springs-co/251spinal-cord-stimulator1
306Spine Deformity Surgery/spine/spine-deformity-surgery-orthopaedic-specialists-colorado-springs-co/251spine-deformity-surgery1
307Neck Surgery/spine/neck-surgery-orthopaedic-specialists-colorado-springs-co/251neck-surgery1
308Spine Surgery in Athletes/spine/spine-surgery-athletes-orthopaedic-specialists-colorado-springs-co/251spine-surgery-in-athletes1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
015
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '25' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
350Spondylodiscitis/spine/spondylodiscitis-orthopaedic-specialists-colorado-springs-co/252spondylodiscitis1
351Benign Spinal Tumors/spine/benign-spinal-tumors-orthopaedic-specialists-colorado-springs-co/252benign-spinal-tumors1
352Spinal Compression Fractures/spine/spinal-compression-fractures-orthopaedic-specialists-colorado-springs-co/252spinal-compression-fractures1
353Spinal Disorders/spine/spinal-disorders-orthopaedic-specialists-colorado-springs-co/252spinal-disorders1
354Fracture of the Thoracic and Lumbar Spine/spine/fracture-thoracic-lumbar-spine-orthopaedic-specialists-colorado-springs-co/252fracture-of-the-thoracic-and-lumbar-spine1
355Spinal Injuries at Work/spine/spinal-injuries-work-orthopaedic-specialists-colorado-springs-co/252spinal-injuries-at-work1
356Spinal Instability/spine/spinal-instability-orthopaedic-specialists-colorado-springs-co/252spinal-instability1
357Spondylolysis/spine/spondylolysis-orthopaedic-specialists-colorado-springs-co/252spondylolysis1
358Vertebral Compression Fractures/spine/vertebral-compression-fractures-orthopaedic-specialists-colorado-springs-co/252vertebral-compression-fractures1
359Back Pain/spine/back-pain-orthopaedic-specialists-colorado-springs-co/252back-pain1
360Spondylolisthesis/spine/spondylolisthesis-orthopaedic-specialists-colorado-springs-co/252spondylolisthesis1
361Spine Deformities/spine/spine-deformities-orthopaedic-specialists-colorado-springs-co/252spine-deformities1
362Facet Joint Arthritis/spine/facet-joint-arthritis-orthopaedic-specialists-colorado-springs-co/252facet-joint-arthritis1
363Sciatica/spine/sciatica-orthopaedic-specialists-colorado-springs-co/252sciatica1
364Fractures of the Spine/spine/fractures-spine-orthopaedic-specialists-colorado-springs-co/252fractures-of-the-spine1
365Scoliosis/spine/scoliosis-orthopaedic-specialists-colorado-springs-co/252scoliosis1
366Degenerative Disc Disease/spine/degenerative-disc-disease-orthopaedic-specialists-colorado-springs-co/252degenerative-disc-disease1
367Spinal Tumors/spine/spinal-tumors-orthopaedic-specialists-colorado-springs-co/252spinal-tumors1
368Spine Injuries in Athletes/spine/spine-injuries-athletes-orthopaedic-specialists-colorado-springs-co/252spine-injuries-in-athletes1
369Kyphosis/spine/kyphosis-orthopaedic-specialists-colorado-springs-co/252kyphosis1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
016
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '26' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
396Lumbar Laminectomy/spine/lumbar-laminectomy-orthopaedic-specialists-colorado-springs-co/261lumbar-laminectomy1
397Lumbar Foraminotomy/spine/lumbar-foraminotomy-orthopaedic-specialists-colorado-springs-co/261lumbar-foraminotomy1
398Lumbar Fusion/spine/lumbar-fusion-orthopaedic-specialists-colorado-springs-co/261lumbar-fusion1
399Lumbar Artificial Disc Replacement/spine/lumbar-artificial-disc-replacement-orthopaedic-specialists-colorado-springs-co/261lumbar-artificial-disc-replacement1
400Lumbar Decompression/spine/lumbar-decompression-orthopaedic-specialists-colorado-springs-co/261lumbar-decompression1
401Posterior Lumbar Interbody Fusion/spine/posterior-lumbar-interbody-fusion-orthopaedic-specialists-colorado-springs-co/261posterior-lumbar-interbody-fusion1
402Lumbar Endoscopic Discectomy/spine/lumbar-endoscopic-discectomy-orthopaedic-specialists-colorado-springs-co/261lumbar-endoscopic-discectomy1
403Lower Back (Lumbar) Surgery/spine/lower-back-lumbar-surgery-orthopaedic-specialists-colorado-springs-co/261lower-back-lumbar-surgery1
404Lumbar Corpectomy and Fusion/spine/lumbar-corpectomy-fusion-orthopaedic-specialists-colorado-springs-co/261lumbar-corpectomy-and-fusion1
405Lumbar Interbody Fusion/spine/lumbar-interbody-fusion-orthopaedic-specialists-colorado-springs-co/261lumbar-interbody-fusion1
406Minimally Invasive Lumbar Discectomy/spine/minimally-invasive-lumbar-discectomy-orthopaedic-specialists-colorado-springs-co/261minimally-invasive-lumbar-discectomy1
407Anterior Lumbar Interbody Fusion/spine/anterior-lumbar-interbody-fusion-orthopaedic-specialists-colorado-springs-co/261anterior-lumbar-interbody-fusion1
408Lumbar Microdiscectomy/spine/lumbar-microdiscectomy-orthopaedic-specialists-colorado-springs-co/261lumbar-microdiscectomy1
409Endoscopic Lumbar Interbody Fusion/spine/endoscopic-lumbar-interbody-fusion-orthopaedic-specialists-colorado-springs-co/261endoscopic-lumbar-interbody-fusion1
410Radiofrequency Ablation for Lumbar Spondylosis/spine/radiofrequency-ablation-lumbar-spondylosis-orthopaedic-specialists-colorado-springs-co/261radiofrequency-ablation-for-lumbar-spondylosis1
411Minimally Invasive Lumbar Decompression (mild Procedure)/spine/minimally-invasive-lumbar-decompression-mild-procedure-orthopaedic-specialists-colorado-springs-co/261minimally-invasive-lumbar-decompression-mild-procedure1
412Minimally Invasive Lumbar Fusion/spine/minimally-invasive-lumbar-fusion-orthopaedic-specialists-colorado-springs-co/261minimally-invasive-lumbar-fusion1
413Anterior Lumbar Corpectomy and Fusion/spine/anterior-lumbar-corpectomy-fusion-orthopaedic-specialists-colorado-springs-co/261anterior-lumbar-corpectomy-and-fusion1
414Lumbar Microdecompression/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/261lumbar-microdecompression1
415Minimally Invasive Lumbar Surgery/spine/minimally-invasive-lumbar-surgery-orthopaedic-specialists-colorado-springs-co/261minimally-invasive-lumbar-surgery1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
017
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '26' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
423Lumbar Stress Fracture/spine/lumbar-stress-fracture-orthopaedic-specialists-colorado-springs-co/262lumbar-stress-fracture1
424Lumbar Radiculopathy/spine/lumbar-radiculopathy-orthopaedic-specialists-colorado-springs-co/262lumbar-radiculopathy1
425Lumbar Herniated Disc/spine/lumbar-herniated-disc-orthopaedic-specialists-colorado-springs-co/262lumbar-herniated-disc1
426Lumbar Stenosis/spine/lumbar-stenosis-orthopaedic-specialists-colorado-springs-co/262lumbar-stenosis1
427Lumbar Degenerative Disc Disease/spine/lumbar-degenerative-disc-disease-orthopaedic-specialists-colorado-springs-co/262lumbar-degenerative-disc-disease1
428Lumbar Sprain/spine/lumbar-sprain-orthopaedic-specialists-colorado-springs-co/262lumbar-sprain1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
018
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '27' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
429Thoracic Laminectomy/spine/thoracic-laminectomy-orthopaedic-specialists-colorado-springs-co/271thoracic-laminectomy1
430Thoracic Spine Trauma Surgery/spine/thoracic-spine-trauma-surgery-orthopaedic-specialists-colorado-springs-co/271thoracic-spine-trauma-surgery1
431Thoracic Discectomy/spine/thoracic-discectomy-orthopaedic-specialists-colorado-springs-co/271thoracic-discectomy1
432Thoracic Spine Decompression/spine/thoracic-spine-decompression-orthopaedic-specialists-colorado-springs-co/271thoracic-spine-decompression1
433Thoracic Spine Fracture Repair Surgery/spine/thoracic-spine-fracture-repair-surgery-orthopaedic-specialists-colorado-springs-co/271thoracic-spine-fracture-repair-surgery1
434Thoracic Kyphoplasty/spine/thoracic-kyphoplasty-orthopaedic-specialists-colorado-springs-co/271thoracic-kyphoplasty1
435Thoracic Corpectomy/spine/thoracic-corpectomy-orthopaedic-specialists-colorado-springs-co/271thoracic-corpectomy1
436Thoracic Spine Fusion/spine/thoracic-spine-fusion-orthopaedic-specialists-colorado-springs-co/271thoracic-spine-fusion1
437Thoracic Vertebroplasty/spine/thoracic-vertebroplasty-orthopaedic-specialists-colorado-springs-co/271thoracic-vertebroplasty1
438Computer Navigated Thoracic Spine Surgery/spine/computer-navigated-thoracic-spine-surgery-orthopaedic-specialists-colorado-springs-co/271computer-navigated-thoracic-spine-surgery1
439Thoracic Facet Joint Injection/spine/thoracic-facet-joint-injection-orthopaedic-specialists-colorado-springs-co/271thoracic-facet-joint-injection1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
019
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '27' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
440Thoracic Pain/spine/thoracic-pain-orthopaedic-specialists-colorado-springs-co/272thoracic-pain1
441Thoracic Outlet Syndrome/spine/thoracic-outlet-syndrome-orthopaedic-specialists-colorado-springs-co/272thoracic-outlet-syndrome1
442Thoracic Disc Herniation/spine/thoracic-disc-herniation-orthopaedic-specialists-colorado-springs-co/272thoracic-disc-herniation1
443Thoracic Myelopathy/spine/thoracic-myelopathy-orthopaedic-specialists-colorado-springs-co/272thoracic-myelopathy1
444Thoracic Nerve Compression/spine/thoracic-nerve-compression-orthopaedic-specialists-colorado-springs-co/272thoracic-nerve-compression1
445Compression of Thoracic Nerve/spine/compression-thoracic-nerve-orthopaedic-specialists-colorado-springs-co/272compression-of-thoracic-nerve1
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
020
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '35' 
    AND type = '1'
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
021
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '35' 
    AND type = '2'
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/spine-sidebar.phprequire_once()36
/home/csogy/public_html/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.phprequire_once()135
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' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/spine/lumbar-microdecompression-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-267',
  'H2_STREAM_ID' => '267',
  '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/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-dwC7ojUlkocvPDub0QABDwQ',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-267',
  'REDIRECT_H2_STREAM_ID' => '267',
  '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/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-dwC7ojUlkocvPDub0QABDwQ',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/spine/lumbar-microdecompression-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702967.009838104248046875,
  'REQUEST_TIME' => 1794702967,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
21! / 0