Lira_Autumn's Profile

User Image

Lira_Autumn

Denver
urbsmith@yahoo.com
(720) 439-9233

Stats:

Age: 29
Weight: 145
Height: 5'4"
Measurements: 32D-27-36
Hair Color: Black
Tattoos: Some
Piercings: None
Body Type: Athletic
Ethnicity: Mixed Race
Eyes: Brown
Grooming: Landing Strip
Smoker: No
Breasts: Natural

Galleries

References: Private

Reviews (54)

Hover over the Review, click to expand and read entire review, click to collapse

Legend: E = Experience, # = Number of Reviews, Date = Review Submitted

Reviewer E # Date
JPMcGuire Yes 16 7/6/24
Seen on 6/28/24
Time: 1 hr Location: BoulderIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: No, fake pictures

Experience Description: Clean and safe with good parking. The massage was very nice and sensual, with plenty of scratching and teasing (I like that). The view on the flip and the finish were very erotic. I do recommend.


Age: 29 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
JustinCredible Yes 3 5/6/24
Seen on 3/31/24
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Unknown

Experience Description: I reached out about a week before and after a quick verification we were set. She was a little late the day of due to traffic but she kept me updated. It was fine and did not impact. The massage was really good. She has strong hands and it was on par with any CMT. The flip was absolutely spectacular.


Age: 29 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Eton83 Yes 12 4/10/24
Seen on 3/29/24
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes

Experience Description: Last minute booking with someone I have had my eye on. First timer. Easy reference check via TOB. Deetz - Amazing FBSM. sexy all the way through. Lira has a great touch and takes care of you. Factr - The flip and final act is something to behold. Conclusion - A sweet and easy going beauty with wonderful skills and a giving personality. Highly recommend. Denver is lucky to have such an exquisite provider.


Age: 29 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Makibnadam Yes 1 9/30/23
Seen on 9/6/23
Time: 30 min Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Unknown

Experience Description: Not too much to add to the other 50 reviews. Lira is down to earth, comforting, and gives a nice FBSM/massage. Convenient location and easy screening, check her out!


Age: 28 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
botox Yes 1 8/2/23
Seen on 7/24/23
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Yes

Experience Description: Had the absolute pleasure of meeting this beautiful lady! face down, getting very relaxed.I found her technique to be firm, soothing and stimulating, at times sending shivers along the length of my body. The flip was nothing short of amazing! As others have said, what are you waiting for? Go in confidence that you will have a nice experience with a lovely lady.


Age: 28 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Explorer90 Yes 6 7/24/23
Seen on 6/18/23
Time: 1.5 hrs Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Unknown

Experience Description: Lira is really amazing. She offers a 10 / 10 star massage experience in a comfortable environment. I can't wait to see her again. The relaxing environment makes for a perfect massage. Music, Oils, all hail in comparison to how beautiful she is and her soft yet soothing massage touch. The massage went by too fast, i certainly recommend going for at least. She wrapped but a smidge early but the fireworks for the grand finale were well worth it. I can't wait to see Lira again and if you're looking for a perfect fbsm, then i'd recommend her


Age: 28 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
TC18 Yes 2 5/3/23
Seen on 3/26/23
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Yes

Experience Description: Had a great experience with Lira from start to finish. Communicating and scheduling with her was easy. Upon arrival She offered warm greeting and I started on face down. She gave a enjoyable massage. I’d definitely recommend her.


Age: 28 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
WhyNot303 Yes 3 3/28/23
Seen on 3/18/23
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Unknown

Experience Description: This woman is amazing! She seemed to know every muscle and joint in my body that needed attention. My shoulders have never felt better! Her hands are so soft yet she can find those deep spots that need extra attention. I will return. It's a must.


Age: 28 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Fish3348 Yes 7 1/14/23
Seen on 12/14/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes

Experience Description: I have seen Lira a few times. She was quick to respond and set up was easy. My first visit I was running late and she still was willing to see me. Which was super cool. She is a beautiful lady and both times I left with a smile on my face.


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
mauturin23 Yes 3 12/4/22
Seen on 11/22/22
Time: 1.5 hrs Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes

Experience Description: Communication was prompt and clear. She was very warm and friendly, and offered a beverage when I entered. a simply amazing massage - she is very good, and ended with an extremely enjoyable flip which is well described in her website - she executes it with perfection. Would definitely recommend and will see her again.


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
SunnyDays Yes 1 11/19/22
Seen on 10/12/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes

Experience Description: This was my first time visiting Lira. Scheduling and screening were simple and straight forward. Her website provides all the information you need. Lira is kind and intelligent. She is as attractive in person as she is in her photos. The location is central, safe and private. The massage was great. It’s clear she really tries to be good at what she does. Would I recommend her? Absolutely!


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
DrDazzle Yes 3 9/24/22
Seen on 9/14/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Yes

Experience Description: I've seen Lira a few times now and it seems to get better every time! Very good massage, great hands, and extremely beautiful.


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Gollstrike4 Yes 27 8/15/22
Seen on 8/6/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes
Additional Website Link: https://liraautumn.wixsite.com/xscape

Experience Description: Bern trying to meet with Lira for a while now and finally our schedules aligned. Safe, location. She greeted me at the door. As far as massages go, it is CMT level, very strong hands with that perfect combo of sensual. the finish was nothing short of amazing. If you’re an active person with muscle aches and want a beautiful masseuse to take care of you, Lira is the one to see.


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Milestyle Yes 3 4/26/22
Seen on 3/21/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Not that I could tell Pictures Accurate: Yes

Experience Description: Lira is a sweetheart. Clear communication and a good host. She provided guidance and smiles throughout. Would highly recommend her.


Age: 27 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Truth1 Yes 1 2/14/22
Seen on 1/12/22
Time: 1 hr Location: DenverIn-Call/Out-Call: In-Call
Experience: Yes Recommend?: Yes Smoking: Unknown Pictures Accurate: Yes

Experience Description: I have seen Lira several times and recommend her very highly. She’s beautiful, attentive, kind, intelligent, and creative. She great from beginning to end. Her screening process is painless, her location is welcoming, and her attitude’s great. She’s a gem. Do yourself a favor with her.


Age: 31 Hair Color: Black Tattoos: Some Piercings: None Body Type: Athletic Ethnicity: Mixed Race Eyes: Brown Grooming: Landing Strip Smoker: No Breasts: Natural Measurements: 32D-27-36
Load More
498.31msRequest Duration27MBMemory UsageGET users/{users}Route
    • Booting (30.14ms)
    • Application (466.24ms)
    • After application (1.07ms)
      55 templates were rendered
      • provider.show (app/views/provider/show.blade.php)6blade
        Params
        0
        user
        1
        provider
        2
        favList
        3
        tab
        4
        showRequest
        5
        showPendingRequest
      • provider.controls (app/views/provider/controls.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
      • provider.show-panel (app/views/provider/show-panel.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        showControls
      • provider.panel (app/views/provider/panel.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        showControls
        12
        ipsMember
      • misc.dynamic-message-popup-sm (app/views/misc/dynamic-message-popup-sm.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        showControls
        12
        ipsMember
      • gallery.show (app/views/gallery/show.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        id
      • gallery.image (app/views/gallery/image.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        id
        13
        image
        14
        isMainImage
      • gallery.image (app/views/gallery/image.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        id
        13
        image
        14
        isMainImage
      • gallery.image (app/views/gallery/image.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        id
        13
        image
        14
        isMainImage
      • gallery.image (app/views/gallery/image.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        id
        13
        image
        14
        isMainImage
      • provider.reviews (app/views/provider/reviews.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
      • reviews.index (app/views/reviews/index.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
      • reviews.help-info (app/views/reviews/help-info.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • reviews.show (app/views/reviews/show.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
      • reviews.details (app/views/reviews/details.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        statusLabel
        13
        reviewerMode
        14
        reviewSet
        15
        review
      • layouts.default (app/views/layouts/default.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
      • auth.panel (app/views/auth/panel.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
      • layouts.base (app/views/layouts/base.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
      • help-popups.ad (app/views/help-popups/ad.blade.php)0blade
      • help-popups.pending-reference-requests (app/views/help-popups/pending-reference-requests.blade.php)0blade
      • help-popups.provider-references (app/views/help-popups/provider-references.blade.php)0blade
      • help-popups.provider-shared-profiles (app/views/help-popups/provider-shared-profiles.blade.php)0blade
      • help-popups.review (app/views/help-popups/review.blade.php)0blade
      • help-popups.reviewer-external-references (app/views/help-popups/reviewer-external-references.blade.php)0blade
      • help-popups.reviewer-references (app/views/help-popups/reviewer-references.blade.php)0blade
      • help-popups.pay-with-bitcoin (app/views/help-popups/pay-with-bitcoin.blade.php)0blade
      • layouts.popup-flash (app/views/layouts/popup-flash.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ipsuser
        5
        user
        6
        provider
        7
        favList
        8
        tab
        9
        showRequest
        10
        showPendingRequest
        11
        gallery
        12
        ipsData
      uri
      GET users/{users}
      as
      users.show
      controller
      ProfileController@show
      file
      app/controllers/ProfileController.php:43-82
      before
      review_account
      210 statements were executed, 16 of which were duplicated209.62ms
      • select * from `users` where `users`.`id` = '114512' limit 1250μs
        Params
        0114512
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `providers` where `user_id` in ('114512')410μs
        Params
        0114512
        hintsUse SELECT * only if you need all columns from table
      • select * from `images` where `images`.`id` in ('35889')300μs
        Params
        035889
        hintsUse SELECT * only if you need all columns from table
      • select * from `ads` where (select count(*) from `users` where `ads`.`user_id` = `users`.`id` and `is_disabled` = '0') >= 1 and `ads`.`user_id` = '114512' and `ads`.`user_id` in ('114512') order by `updated_at` desc590μs
        Params
        00
        1114512
        2114512
        hintsUse SELECT * only if you need all columns from table
      • select * from `galleries` where `galleries`.`id` in ('8684')280μs
        Params
        08684
        hintsUse SELECT * only if you need all columns from table
      • select `images`.*, `gallery_images`.`gallery_id` as `pivot_gallery_id`, `gallery_images`.`image_id` as `pivot_image_id`, `gallery_images`.`created_at` as `pivot_created_at`, `gallery_images`.`updated_at` as `pivot_updated_at` from `images` inner join `gallery_images` on `images`.`id` = `gallery_images`.`image_id` where `gallery_images`.`gallery_id` in ('8684') order by `pivot_created_at` desc440μs
        Params
        08684
        hintsUse SELECT * only if you need all columns from table
      • select * from `users` where `users`.`id` in ('114512')360μs
        Params
        0114512
        hintsUse SELECT * only if you need all columns from table
      • select * from `providers` where `providers`.`user_id` in ('114512')320μs
        Params
        0114512
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `provider_values`.`user_id` as `pivot_user_id`, `provider_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `provider_values` on `provider_field_values`.`id` = `provider_values`.`value_id` where `provider_values`.`user_id` in ('114512')370μs
        Params
        0114512
      • select * from `provider_fields` where `provider_fields`.`id` in ('1', '2', '3', '4', '5', '6', '7', '8', '9')190μs
        Params
        01
        12
        23
        34
        45
        56
        67
        78
        89
        hintsUse SELECT * only if you need all columns from table
      • select * from `reviews` where `status` = '1' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0') >= 1 and `approved_at` <= '2025-04-17 21:48:14' and `reviews`.`provider_id` in ('114512')25.19ms
        Params
        01
        10
        22025-04-17 21:48:14
        3114512
        hintsUse SELECT * only if you need all columns from table
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('67047', '67936', '68078', '68215', '68227', '68479', '68892', '69232', '69471', '70949', '71174', '74117', '74146', '74615', '75256', '77867', '78043', '78432', '79662', '79902', '80223', '80678', '82089', '83086', '83932', '85817', '86026', '86866', '87407', '87586', '87845', '87961', '89238', '89548', '90601', '90687', '91506', '91692', '92739', '92900', '93324', '93334', '93887', '94803', '95081', '95475', '95558', '95801', '96307', '96603', '97147', '97207', '97681', '98958', '99145', '99538')1.48ms
        Params
        01
        167047
        267936
        368078
        468215
        568227
        668479
        768892
        869232
        969471
        1070949
        1171174
        1274117
        1374146
        1474615
        1575256
        1677867
        1778043
        1878432
        1979662
        2079902
        2180223
        2280678
        2382089
        2483086
        2583932
        2685817
        2786026
        2886866
        2987407
        3087586
        3187845
        3287961
        3389238
        3489548
        3590601
        3690687
        3791506
        3891692
        3992739
        4092900
        4193324
        4293334
        4393887
        4494803
        4595081
        4695475
        4795558
        4895801
        4996307
        5096603
        5197147
        5297207
        5397681
        5498958
        5599145
        5699538
        hintsUse SELECT * only if you need all columns from table
      • select * from `reviewers` where `reviewers`.`user_id` in ('116601', '120592', '119897', '100855', '121247', '99629', '96880', '108131', '97001', '97468', '125688', '101845', '106896', '123545', '97829', '132742', '96566', '133084', '123070', '137356', '95918', '100935', '132615', '99994', '141076', '136988', '140776', '142783', '140730', '113278', '129012', '94851', '143404', '146346', '140485', '118287', '94920', '153549', '95531', '154247', '159905', '124329', '160742', '161138', '96493', '138357', '161098', '164249', '160967', '160561', '128776', '114629', '166468', '116980')830μs
        Params
        0116601
        1120592
        2119897
        3100855
        4121247
        599629
        696880
        7108131
        897001
        997468
        10125688
        11101845
        12106896
        13123545
        1497829
        15132742
        1696566
        17133084
        18123070
        19137356
        2095918
        21100935
        22132615
        2399994
        24141076
        25136988
        26140776
        27142783
        28140730
        29113278
        30129012
        3194851
        32143404
        33146346
        34140485
        35118287
        3694920
        37153549
        3895531
        39154247
        40159905
        41124329
        42160742
        43161138
        4496493
        45138357
        46161098
        47164249
        48160967
        49160561
        50128776
        51114629
        52166468
        53116980
        hintsUse SELECT * only if you need all columns from table
      • select * from `users` where `users`.`userable_id` in ('94851', '94920', '95531', '95918', '96493', '96566', '96880', '97001', '97468', '97829', '99629', '99994', '100855', '100935', '101845', '106896', '108131', '113278', '114629', '116601', '116980', '118287', '119897', '120592', '121247', '123070', '123545', '124329', '125688', '128776', '129012', '132615', '132742', '133084', '136988', '137356', '138357', '140485', '140730', '140776', '141076', '142783', '143404', '146346', '153549', '154247', '159905', '160561', '160742', '160967', '161098', '161138', '164249', '166468') and `users`.`userable_type` = 'Reviewer'2.54ms
        Params
        094851
        194920
        295531
        395918
        496493
        596566
        696880
        797001
        897468
        997829
        1099629
        1199994
        12100855
        13100935
        14101845
        15106896
        16108131
        17113278
        18114629
        19116601
        20116980
        21118287
        22119897
        23120592
        24121247
        25123070
        26123545
        27124329
        28125688
        29128776
        30129012
        31132615
        32132742
        33133084
        34136988
        35137356
        36138357
        37140485
        38140730
        39140776
        40141076
        41142783
        42143404
        43146346
        44153549
        45154247
        46159905
        47160561
        48160742
        49160967
        50161098
        51161138
        52164249
        53166468
        54Reviewer
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `provider_values`.`user_id` as `pivot_user_id`, `provider_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `provider_values` on `provider_field_values`.`id` = `provider_values`.`value_id` where `provider_values`.`user_id` in ('114512')220μs
        Params
        0114512
      • select * from `provider_fields` where `provider_fields`.`id` in ('1', '2', '3', '4', '5', '6', '7', '8', '9')180μs
        Params
        01
        12
        23
        34
        45
        56
        67
        78
        89
        hintsUse SELECT * only if you need all columns from table
      • select * from `galleries` where `galleries`.`user_id` in ('114512') order by `id` desc330μs
        Params
        0114512
        hintsUse SELECT * only if you need all columns from table
      • select `images`.*, `gallery_images`.`gallery_id` as `pivot_gallery_id`, `gallery_images`.`image_id` as `pivot_image_id`, `gallery_images`.`created_at` as `pivot_created_at`, `gallery_images`.`updated_at` as `pivot_updated_at` from `images` inner join `gallery_images` on `images`.`id` = `gallery_images`.`image_id` where `gallery_images`.`gallery_id` in ('8684') order by `pivot_created_at` desc210μs
        Params
        08684
        hintsUse SELECT * only if you need all columns from table
      • select * from `reviews` where `status` = '1' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0') >= 1 and `approved_at` <= '2025-04-17 21:48:14' and `reviews`.`provider_id` in ('114512')1.99ms
        Params
        01
        10
        22025-04-17 21:48:14
        3114512
        hintsUse SELECT * only if you need all columns from table
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('67047', '67936', '68078', '68215', '68227', '68479', '68892', '69232', '69471', '70949', '71174', '74117', '74146', '74615', '75256', '77867', '78043', '78432', '79662', '79902', '80223', '80678', '82089', '83086', '83932', '85817', '86026', '86866', '87407', '87586', '87845', '87961', '89238', '89548', '90601', '90687', '91506', '91692', '92739', '92900', '93324', '93334', '93887', '94803', '95081', '95475', '95558', '95801', '96307', '96603', '97147', '97207', '97681', '98958', '99145', '99538')400μs
        Params
        01
        167047
        267936
        368078
        468215
        568227
        668479
        768892
        869232
        969471
        1070949
        1171174
        1274117
        1374146
        1474615
        1575256
        1677867
        1778043
        1878432
        1979662
        2079902
        2180223
        2280678
        2382089
        2483086
        2583932
        2685817
        2786026
        2886866
        2987407
        3087586
        3187845
        3287961
        3389238
        3489548
        3590601
        3690687
        3791506
        3891692
        3992739
        4092900
        4193324
        4293334
        4393887
        4494803
        4595081
        4695475
        4795558
        4895801
        4996307
        5096603
        5197147
        5297207
        5397681
        5498958
        5599145
        5699538
        hintsUse SELECT * only if you need all columns from table
      • select * from `reviewers` where `reviewers`.`user_id` in ('116601', '120592', '119897', '100855', '121247', '99629', '96880', '108131', '97001', '97468', '125688', '101845', '106896', '123545', '97829', '132742', '96566', '133084', '123070', '137356', '95918', '100935', '132615', '99994', '141076', '136988', '140776', '142783', '140730', '113278', '129012', '94851', '143404', '146346', '140485', '118287', '94920', '153549', '95531', '154247', '159905', '124329', '160742', '161138', '96493', '138357', '161098', '164249', '160967', '160561', '128776', '114629', '166468', '116980')470μs
        Params
        0116601
        1120592
        2119897
        3100855
        4121247
        599629
        696880
        7108131
        897001
        997468
        10125688
        11101845
        12106896
        13123545
        1497829
        15132742
        1696566
        17133084
        18123070
        19137356
        2095918
        21100935
        22132615
        2399994
        24141076
        25136988
        26140776
        27142783
        28140730
        29113278
        30129012
        3194851
        32143404
        33146346
        34140485
        35118287
        3694920
        37153549
        3895531
        39154247
        40159905
        41124329
        42160742
        43161138
        4496493
        45138357
        46161098
        47164249
        48160967
        49160561
        50128776
        51114629
        52166468
        53116980
        hintsUse SELECT * only if you need all columns from table
      • select * from `users` where `users`.`userable_id` in ('94851', '94920', '95531', '95918', '96493', '96566', '96880', '97001', '97468', '97829', '99629', '99994', '100855', '100935', '101845', '106896', '108131', '113278', '114629', '116601', '116980', '118287', '119897', '120592', '121247', '123070', '123545', '124329', '125688', '128776', '129012', '132615', '132742', '133084', '136988', '137356', '138357', '140485', '140730', '140776', '141076', '142783', '143404', '146346', '153549', '154247', '159905', '160561', '160742', '160967', '161098', '161138', '164249', '166468') and `users`.`userable_type` = 'Reviewer'1.47ms
        Params
        094851
        194920
        295531
        395918
        496493
        596566
        696880
        797001
        897468
        997829
        1099629
        1199994
        12100855
        13100935
        14101845
        15106896
        16108131
        17113278
        18114629
        19116601
        20116980
        21118287
        22119897
        23120592
        24121247
        25123070
        26123545
        27124329
        28125688
        29128776
        30129012
        31132615
        32132742
        33133084
        34136988
        35137356
        36138357
        37140485
        38140730
        39140776
        40141076
        41142783
        42143404
        43146346
        44153549
        45154247
        46159905
        47160561
        48160742
        49160967
        50161098
        51161138
        52164249
        53166468
        54Reviewer
        hintsUse SELECT * only if you need all columns from table
      • select * from `cities` where `cities`.`id` in ('18', '23')220μs
        Params
        018
        123
        hintsUse SELECT * only if you need all columns from table
      • select * from `cities` where `cities`.`id` = '18' limit 1220μs
        Params
        018
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `images`.*, `gallery_images`.`gallery_id` as `pivot_gallery_id`, `gallery_images`.`image_id` as `pivot_image_id`, `gallery_images`.`created_at` as `pivot_created_at`, `gallery_images`.`updated_at` as `pivot_updated_at` from `images` inner join `gallery_images` on `images`.`id` = `gallery_images`.`image_id` where `gallery_images`.`gallery_id` = '8684' and `image_id` in ('35893') order by `pivot_created_at` desc390μs
        Params
        08684
        135893
        hintsUse SELECT * only if you need all columns from table
      • select `images`.*, `gallery_images`.`gallery_id` as `pivot_gallery_id`, `gallery_images`.`image_id` as `pivot_image_id`, `gallery_images`.`created_at` as `pivot_created_at`, `gallery_images`.`updated_at` as `pivot_updated_at` from `images` inner join `gallery_images` on `images`.`id` = `gallery_images`.`image_id` where `gallery_images`.`gallery_id` = '8684' and `image_id` not in ('35893') order by `pivot_created_at` desc630μs
        Params
        08684
        135893
        hintsUse SELECT * only if you need all columns from table
      • select provider_id, COUNT(*) as review_count from (SELECT provider_id, COUNT(*) FROM `reviews` WHERE `status` = 1 AND `approved_at` <= '2025-04-17T21:48:14+0000' GROUP BY `provider_id`, `reviewer_id`) as reviews where `reviews`.`provider_id` = '114512' group by `provider_id`120.72ms
        Params
        0114512
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('')220μs
        Params
        01
        1
        hintsUse SELECT * only if you need all columns from table
      • select `id` from `reviews` where `reviews`.`provider_id` = '114512' and `status` = '1' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0') >= 1 and `approved_at` <= '2025-04-17 21:48:14' order by `created_at` desc limit 16 offset 012.55ms
        Params
        0114512
        11
        20
        32025-04-17 21:48:14
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('99538', '99145', '98958', '97681', '97207', '97147', '96603', '96307', '95801', '95558', '95475', '95081', '94803', '93887', '93334', '93324')450μs
        Params
        01
        199538
        299145
        398958
        497681
        597207
        697147
        796603
        896307
        995801
        1095558
        1195475
        1295081
        1394803
        1493887
        1593334
        1693324
        hintsUse SELECT * only if you need all columns from table
      • select * from `reviews` where `reviews`.`reviewer_id` = '116980' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'920μs
        Params
        0116980
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('66546', '66563', '67095', '67237', '67329', '67575', '68866', '69753', '70771', '81260', '82185', '82997', '84749', '87849', '99344', '99538')280μs
        Params
        01
        166546
        266563
        367095
        467237
        567329
        667575
        768866
        869753
        970771
        1081260
        1182185
        1282997
        1384749
        1487849
        1599344
        1699538
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '99538'450μs
        Params
        099538
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1180μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1140μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1110μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1130μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1120μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1110μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1130μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1140μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '166468' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'680μs
        Params
        0166468
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('98442', '99130', '99145')260μs
        Params
        01
        198442
        299130
        399145
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '99145'490μs
        Params
        099145
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1160μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1180μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1140μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1180μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1150μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1200μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1140μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1160μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1160μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '114629' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'580μs
        Params
        0114629
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('93374', '94384', '95150', '95170', '95914', '96176', '96381', '96755', '96763', '97644', '98958', '99122')210μs
        Params
        01
        193374
        294384
        395150
        495170
        595914
        696176
        796381
        896755
        996763
        1097644
        1198958
        1299122
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '98958'330μs
        Params
        098958
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1110μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1140μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1130μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1110μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1120μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1140μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1170μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '128776' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'580μs
        Params
        0128776
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('97681')230μs
        Params
        01
        197681
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '97681'380μs
        Params
        097681
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1160μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1110μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1130μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '160561' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'550μs
        Params
        0160561
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('97207')250μs
        Params
        01
        197207
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '97207'350μs
        Params
        097207
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1130μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1140μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1110μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1150μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1120μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1150μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1130μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '160967' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'760μs
        Params
        0160967
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('94849', '96211', '97147', '97149', '98427', '100061')290μs
        Params
        01
        194849
        296211
        397147
        497149
        598427
        6100061
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '97147'350μs
        Params
        097147
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1140μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1130μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1150μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1120μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1200μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1110μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '164249' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'590μs
        Params
        0164249
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('96291', '96603')250μs
        Params
        01
        196291
        296603
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '96603'320μs
        Params
        096603
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1140μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1140μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1130μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1140μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1140μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1120μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1110μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '161098' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'590μs
        Params
        0161098
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('95824', '96307', '96719')310μs
        Params
        01
        195824
        296307
        396719
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '96307'330μs
        Params
        096307
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1160μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1130μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1110μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1140μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1110μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1130μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '138357' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'410μs
        Params
        0138357
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('81719', '81967', '82166', '95093', '95801', '99361', '99843')170μs
        Params
        01
        181719
        281967
        382166
        495093
        595801
        699361
        799843
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '95801'380μs
        Params
        095801
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1120μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1110μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1100μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1110μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1100μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '96493' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'600μs
        Params
        096493
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('90221', '95558', '97214')330μs
        Params
        01
        190221
        295558
        397214
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '95558'370μs
        Params
        095558
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1150μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1130μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1110μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1170μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1140μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1140μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '161138' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'570μs
        Params
        0161138
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('95475')290μs
        Params
        01
        195475
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '95475'330μs
        Params
        095475
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1220μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1120μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1110μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1120μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1120μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '160742' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'310μs
        Params
        0160742
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('95081', '96233', '98271')160μs
        Params
        01
        195081
        296233
        398271
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '95081'340μs
        Params
        095081
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1140μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1120μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1110μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1110μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1110μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '124329' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'720μs
        Params
        0124329
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('70146', '70147', '70213', '70454', '70762', '72089', '72718', '73196', '73756', '74243', '74466', '75022', '77241', '77800', '77957', '78132', '78285', '79167', '88969', '90615', '92914', '93664', '93844', '94315', '94803', '98076', '101017')250μs
        Params
        01
        170146
        270147
        370213
        470454
        570762
        672089
        772718
        873196
        973756
        1074243
        1174466
        1275022
        1377241
        1477800
        1577957
        1678132
        1778285
        1879167
        1988969
        2090615
        2192914
        2293664
        2393844
        2494315
        2594803
        2698076
        27101017
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '94803'380μs
        Params
        094803
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1140μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1130μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1130μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1120μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1140μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1130μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1120μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '159905' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'290μs
        Params
        0159905
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('93887', '93960', '95612')150μs
        Params
        01
        193887
        293960
        395612
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '93887'350μs
        Params
        093887
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1120μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1110μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1130μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1150μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1130μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1120μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1120μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1130μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `reviews` where `reviews`.`reviewer_id` = '154247' and `status` != '2' and (select count(*) from `providers` where `reviews`.`provider_id` = `providers`.`user_id` and `hide_reviews` = '0' and `hide_profile` = '0') >= 1 and `status` = '1'550μs
        Params
        0154247
        12
        20
        30
        41
        hintsUse SELECT * only if you need all columns from table
        The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `review_rebuttals` where `status` = '1' and `review_rebuttals`.`review_id` in ('93334')230μs
        Params
        01
        193334
        hintsUse SELECT * only if you need all columns from table
      • select `provider_field_values`.*, `review_values`.`review_id` as `pivot_review_id`, `review_values`.`value_id` as `pivot_value_id` from `provider_field_values` inner join `review_values` on `provider_field_values`.`id` = `review_values`.`value_id` where `review_values`.`review_id` = '93334'360μs
        Params
        093334
      • select * from `provider_fields` where `provider_fields`.`id` = '1' limit 1130μs
        Params
        01
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '2' limit 1120μs
        Params
        02
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '3' limit 1120μs
        Params
        03
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '4' limit 1130μs
        Params
        04
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '5' limit 1120μs
        Params
        05
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '6' limit 1120μs
        Params
        06
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '7' limit 1110μs
        Params
        07
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '8' limit 1110μs
        Params
        08
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `provider_fields` where `provider_fields`.`id` = '9' limit 1110μs
        Params
        09
        hintsUse SELECT * only if you need all columns from table
        LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        format
        html
        content_type
        text/html; charset=UTF-8
        status_text
        OK
        status_code
        200
        request_query
        []
        request_request
        []
        request_headers
        array:16 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,i...
        request_server
        array:49 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
        request_cookies
        []
        response_headers
        array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Thu...
        path_info
        /users/114512
        session_attributes
        array:3 [ "_token" => "Teza6GDrkREfN5cEtElZzmCAYHCzaIwArX7Iw4IK" "ipsuser" => IPS\Member {#2407 ...