Skip to main content
You need to log in or register for storing your searches

Properties listing

15 of 1366 Properties
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Active
40
1/40
Captivating Mediterranean style Harbor Town Home that features a Chefs Kitchen with limestone flooring and Viking appliances, custom crown molding, 5 bedrooms and 4 full baths. Tile roof, real cement stucco, new Marvin windows, 3rd floor media room. Awesome roof top terrace with fantastic views. Spacious floor plan with open flow. 3 fireplaces, hardwood floors, charming court yard patio and large 2 car garage. Primary bedroom features 3 walk-in closets. Additional bedrooms feature walk-in closet…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
Active
37
1/37
Wonderful 4 Bed 2.5 Bath Move In Ready Home in Lakeland - Formal Dining Room - Great Room with Fireplace - Primary Down with Fabulous Walk In Closet and Attached Office that could make a great Nursery, Work Out Room, Reading Room, 5th Bedroom or Anything You Can Imagine - Spacious Kitchen Offering Storage, Breakfast Bar, and Eating Area - Check Out The HUGE Laundry Room - Upstairs Features 3 Bedrooms, 1 could be a Bonus Room, And A Bathroom - Plus a Great Loft Area For The Kids To Enjoy - Inside…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
Active
10
1/10
Detached Single Family
3
1.1
1200 sqft
Recently updated 3 bedroom, 1.5 bath brick home centrally located on a quiet dead end street in Ripley. Home has a one car carport, a nice private backyard and a nice covered back porch. New vinyl plank flooring, new kitchen countertops and fresh paint throughout. New Roof and Central Unit (Both Less than 2 years old) Call today to set up your private viewing.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Active
40
1/40
Detached Single Family
6
6.3
10000 sqft
Spectacular estate built in 2012 in sought after East Memphis location! 12,000+ sqft/1.9 acres. 6 Bedrooms/6 full baths/3 half baths + attached suite featuring Eat-In-Kitchen, Living Room w/fireplace, family room w/ fireplace and soaring views. Kitchen w/ granite, ss appliances, gas cooking. 3 screened porches. All bedrooms designed as suites, Primary on main floor, luxury bath w/ huge closets and laundry. Entire home has heated floors & solid oak floors. Huge cedar closet, elevator to all f…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Pending
40
1/40
Sellers are willing to help with closing costs! Please bring an offer!!! Relax in the glistening pool, roast marshmallows over the fire pit, grill under the covered patio or watch TV under the huge covered outdoor living area! Welcome to your 2 acre paradise in a cove! With 4 beds, 2 offices, PLUS a bonus, there is room for everyone (the bonus & offices can even be used as addt'l beds if needed). This home also boasts gorgeous stained concrete floors, double entry front doors, 3 car g…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
Active
33
1/33
Detached Single Family
3
2
1800 sqft
Welcome to this charming home nestled in the highly sought-after Colonial Acres! Featuring beautiful hardwood and tiled floors throughout, this home boasts a spacious family room with a cozy fireplace and gas logs. With three bedrooms, two full baths, and an additional office space, there’s room for everyone. Enjoy the convenience of a large laundry room, and step outside to relax on the deck overlooking a big backyard—perfect for entertaining. All appliances remain, making this move-in ready ho…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
Active
20
1/20
same as above.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
Pending
10
1/10
Grays Hollow: A Regency Homebuilders community in Cordova. This Crosby floor plan is a 3114 square foot home featuring 9 foot ceilings downstairs and 8 foot ceilings upstairs, as well as open concept living. Estimated Completion: June 2025
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
Active
32
1/32
Corner Unit Condo in Downtown Memphis on Mud Island. Open floor plan with 2 bedroom and 2 baths. Two balconies with river views. Top floor unit with beautiful hardwood floors, granite countertops and stainless steel appliances. Primary bedroom has a generous walk-in closet. Primary bath has double vanities. Community Pool. You can park across the street. Steps from the river. Professional pictures coming 10-16-2024.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Pending
40
1/40
This incredible home was designed by Charles Shipp and custom built by renowned builder, Hank Hill, for the current owners. It is located on a gorgeous 1 acre cove lot in the exclusive GATED Orchard Hill neighborhood in the heart of Germantown. You may have passed by here many times without even noticing the entrance, set far back from Poplar. Outstanding street appeal with painted brick exterior and Santa Ana clay tile lifetime roof. With 5 bedrooms, 5 baths and 3 half baths, and over 8700 SF,…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
Pending
10
1/10
Completely renovated 2 bed 1 bath home with excellent location. Convenient to downtown and all things midtown. Move right in without having to worry about anything or use this as an investment property and don't worry about making repairs or renovations!
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
Active
34
1/34
Attached Single Family
3
2.1
1800 sqft
A Magnificent Investment Opportunity !! New roof , Washer , Dryer and Refrigerator included, New Interior and New Exterior paint September 2024, Primary bedroom also has a Balcony, New Electric hot water heater ,Front and Rear Tree has been removed, And wait for this...It's Huge (1800 square feet) with 3 Bedrooms & 2.5 bathrooms. 2 car private carport. Currently being Leased . Less than 2 miles from Southaven,MS * Do Not Disturb the Tenants.** No Sign in the Yard.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
Active
16
1/16
Detached Single Family
3
1
1200 sqft
Calling all investors! HUGE PRICE DROP....Great Opportunity. This home is for sale! Needs repairs but could be worth a lot of money once fixed up. Some repairs have been completed and the electrical is currently on! Can fix it up and sell for a lot of money or keep it and live in it. Many homes in this area are being rehabbed & sold for more money! ONLINE VIDEO AVAILABLE UPON REQUEST. No wholesalers or assignments and no creative financing. Seller is also selling 324 Outer Parkway (can buy…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
Active
30
1/30
Detached Single Family
4
3
2000 sqft
4 bedroom 3 full baths, Completely remodeled to studs. Secure parking behind fence. Granite, all new bathrooms. New flooring, paint, doors, cabinets, Lights, fixtures & more. 2 Primary bedrooms with En Suite baths! Walk to St. Jude, downtown restaurants & attractions. New Roof. New HVAC to be installed before closing. Huge kitchen & pantry. Over 2,100 sq ft on 1 level. Fenced backyard with driveway & parking behind fence. Easy to see, call today!
  •  - Image# 1
Pending
Gated community in Cordova (Crytal Lake Subdivison). This two story home features four bedrooms, three and a half baths, living room, dinning room, oversize kitchen with hearth sitting area, master bedroom plus one other bedroom and two full baths downstairs, two bedrooms, bonus room and full bathroom upstairs, 2 car gargage and a patio. Excellent house for entertaining or for the growing family. Schedule a showing today.
10.578MBMemory Usage643msRequest Duration
Joomla! Version5.1.2
PHP Version8.3.20
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.11.11-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "240" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "PHP_INI_SCAN_DIR" => "/etc/opt/remi/php83/php.d:/home/tharrald/public_html" "PATH" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744520953 "last" => 1744520953...
registry
array:3 [ "data" => array:1 [ "com_fwrealestate" => array:2 [ "currency" => 1 "mes...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (71.1KB) (12.26ms)
  • afterInitialise (2.37MB) (73.7ms)
  • afterRoute (1.82MB) (33.57ms)
  • beforeRenderComponent com_fwrealestate (7.92KB) (2.33ms)
  • Before Access::preloadComponents (all components) (2.04MB) (142ms)
  • After Access::preloadComponents (all components) (145.36KB) (1.13ms)
  • Before Access::getAssetRules (id:1 name:root.1) (104B) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.2KB) (350μs)
  • afterRenderComponent com_fwrealestate (1.62MB) (173ms)
  • afterDispatch (83KB) (3.91ms)
  • beforeRenderRawModule mod_yootheme_builder (Property Search Display) (149.95KB) (27.32ms)
  • beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (2.42ms)
  • afterRenderRawModule mod_fwre_search (Property Search) (151.27KB) (91.05ms)
  • beforeRenderModule mod_fwre_search (Property Search) (720B) (17μs)
  • afterRenderModule mod_fwre_search (Property Search) (3.91KB) (822μs)
  • afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.05KB) (7.74ms)
  • beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (13μs)
  • afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (178μs)
  • beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (6.49ms)
  • afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.05KB) (5.35ms)
  • beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (18μs)
  • afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.37KB) (463μs)
  • beforeRenderRawModule mod_custom () (13.41KB) (19.47ms)
  • afterRenderRawModule mod_custom () (40.01KB) (5.58ms)
  • beforeRenderModule mod_custom () (704B) (14μs)
  • afterRenderModule mod_custom () (1.81KB) (206μs)
  • beforeRenderRawModule mod_menu () (1.41KB) (413μs)
  • afterRenderRawModule mod_menu () (45.84KB) (3.93ms)
  • beforeRenderModule mod_menu () (696B) (12μs)
  • afterRenderModule mod_menu () (3.41KB) (308μs)
  • beforeRenderRawModule mod_custom () (1.28KB) (475μs)
  • afterRenderRawModule mod_custom () (944B) (507μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (3.06KB) (178μs)
  • beforeRenderRawModule mod_custom () (1.11KB) (318μs)
  • afterRenderRawModule mod_custom () (896B) (986μs)
  • beforeRenderModule mod_custom () (704B) (11μs)
  • afterRenderModule mod_custom () (1.81KB) (165μs)
  • beforeRenderRawModule mod_custom () (2.61KB) (610μs)
  • afterRenderRawModule mod_custom () (896B) (1.22ms)
  • beforeRenderModule mod_custom () (704B) (16μs)
  • afterRenderModule mod_custom () (1.81KB) (184μs)
  • beforeRenderRawModule mod_custom () (184B) (26μs)
  • afterRenderRawModule mod_custom () (816B) (409μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.81KB) (176μs)
  • beforeRenderRawModule mod_menu () (376B) (29μs)
  • afterRenderRawModule mod_menu () (2.27KB) (2.09ms)
  • beforeRenderModule mod_menu () (696B) (9μs)
  • afterRenderModule mod_menu () (1.81KB) (170μs)
  • beforeRenderRawModule mod_custom () (5.98KB) (1.06ms)
  • afterRenderRawModule mod_custom () (896B) (440μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (2.94KB) (197μs)
  • beforeRenderRawModule mod_custom () (880B) (416μs)
  • afterRenderRawModule mod_custom () (896B) (408μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (3.78KB) (214μs)
  • afterRender (487.53KB) (16.25ms)
  • 1 x afterRenderComponent com_fwrealestate (1.62MB) (26.96%)
    173ms
    1 x Before Access::preloadComponents (all components) (2.04MB) (22.13%)
    142ms
    1 x afterRenderRawModule mod_fwre_search (Property Search) (151.27KB) (14.16%)
    91.05ms
    1 x afterInitialise (2.37MB) (11.46%)
    73.70ms
    1 x afterRoute (1.82MB) (5.22%)
    33.57ms
    1 x beforeRenderRawModule mod_yootheme_builder (Property Search Display) (149.95KB) (4.25%)
    27.32ms
    1 x beforeRenderRawModule mod_custom () (13.41KB) (3.03%)
    19.47ms
    1 x afterRender (487.53KB) (2.53%)
    16.25ms
    1 x afterLoad (71.1KB) (1.91%)
    12.26ms
    1 x afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.05KB) (1.2%)
    7.74ms
    1 x beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (1.01%)
    6.49ms
    1 x afterRenderRawModule mod_custom () (40.01KB) (0.87%)
    5.58ms
    1 x afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.05KB) (0.83%)
    5.35ms
    1 x afterRenderRawModule mod_menu () (45.84KB) (0.61%)
    3.93ms
    1 x afterDispatch (83KB) (0.61%)
    3.91ms
    4 x afterRenderRawModule mod_custom () (896B) (0.47%)
    3.05ms
    1 x beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (0.38%)
    2.42ms
    1 x beforeRenderComponent com_fwrealestate (7.92KB) (0.36%)
    2.33ms
    1 x afterRenderRawModule mod_menu () (2.27KB) (0.32%)
    2.09ms
    1 x After Access::preloadComponents (all components) (145.36KB) (0.18%)
    1.13ms
    1 x beforeRenderRawModule mod_custom () (5.98KB) (0.17%)
    1.06ms
    1 x afterRenderModule mod_fwre_search (Property Search) (3.91KB) (0.13%)
    822μs
    4 x afterRenderModule mod_custom () (1.81KB) (0.11%)
    731μs
    1 x beforeRenderRawModule mod_custom () (2.61KB) (0.09%)
    610μs
    1 x afterRenderRawModule mod_custom () (944B) (0.08%)
    507μs
    1 x beforeRenderRawModule mod_custom () (1.28KB) (0.07%)
    475μs
    1 x afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.37KB) (0.07%)
    463μs
    1 x beforeRenderRawModule mod_custom () (880B) (0.06%)
    416μs
    1 x beforeRenderRawModule mod_menu () (1.41KB) (0.06%)
    413μs
    1 x afterRenderRawModule mod_custom () (816B) (0.06%)
    409μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0.05%)
    350μs
    1 x beforeRenderRawModule mod_custom () (1.11KB) (0.05%)
    318μs
    1 x afterRenderModule mod_menu () (3.41KB) (0.05%)
    308μs
    1 x afterRenderModule mod_custom () (3.78KB) (0.03%)
    214μs
    1 x afterRenderModule mod_custom () (2.94KB) (0.03%)
    197μs
    1 x afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (0.03%)
    178μs
    1 x afterRenderModule mod_custom () (3.06KB) (0.03%)
    178μs
    1 x afterRenderModule mod_menu () (1.81KB) (0.03%)
    170μs
    7 x beforeRenderModule mod_custom () (704B) (0.01%)
    80μs
    1 x beforeRenderRawModule mod_menu () (376B) (0%)
    29μs
    1 x beforeRenderRawModule mod_custom () (184B) (0%)
    26μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%)
    25μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    21μs
    1 x beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (0%)
    18μs
    1 x beforeRenderModule mod_fwre_search (Property Search) (720B) (0%)
    17μs
    1 x beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (0%)
    13μs
46 statements were executed143ms423.16KB
  • SELECT @@SESSION.sql_mode;172μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos3l_session` WHERE `session_id` = ?304μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = :session_id LIMIT 1208μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.64ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos3l_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1238μs81.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos3l_viewlevels`157μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos3l_usergroups` AS `a` LEFT JOIN `jos3l_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest102μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos3l_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`318μs133.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system'195μs1.15KB/plugins/system/yooessentials/helper.php:152Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos3l_menu` AS `m` LEFT JOIN `jos3l_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`245μs19.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `jos3l_languages` WHERE `published` = 1 ORDER BY `ordering` ASC170μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos3l_template_styles` AS `s` LEFT JOIN `jos3l_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1160μs16.83KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1101μs536B/plugins/system/yooessentials/modules/core-joomla/src/Database.php:53Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_currency AS t ORDER BY name, eng, any150μs960B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT p.*, (SELECT g.image FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1 ORDER BY g.ordering, g.id LIMIT 1) AS _image, (SELECT g.alt FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1 ORDER BY g.ordering, g.id LIMIT 1) AS _image_alt, (SELECT COUNT(*) FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1) AS _images_qty, pt.street_direction AS _street_direction, (SELECT rt.street_direction FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _street_direction_eng_translation, (SELECT rt.street_direction FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.street_direction <> '' LIMIT 1) AS _street_direction_any_translation, pt.street_suffix AS _street_suffix, (SELECT rt.street_suffix FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _street_suffix_eng_translation, (SELECT rt.street_suffix FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.street_suffix <> '' LIMIT 1) AS _street_suffix_any_translation, pt.property_title AS _property_title, (SELECT rt.property_title FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _property_title_eng_translation, (SELECT rt.property_title FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.property_title <> '' LIMIT 1) AS _property_title_any_translation, pt.property_desc AS _property_desc, (SELECT rt.property_desc FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _property_desc_eng_translation, (SELECT rt.property_desc FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.property_desc <> '' LIMIT 1) AS _property_desc_any_translation, pt.address AS _address, (SELECT rt.address FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _address_eng_translation, (SELECT rt.address FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.address <> '' LIMIT 1) AS _address_any_translation, pt.price AS _price, (SELECT rt.price FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _price_eng_translation, (SELECT rt.price FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.price <> '' LIMIT 1) AS _price_any_translation, pcot.name AS _country_name, pret.name AS _region_name, pct.name AS _city_name, (SELECT name FROM jos3l_fwre_exterior_translation AS et WHERE et.exterior_id = p.exterior_id AND lang = 'en-GB' LIMIT 1) AS _exterior_name, (SELECT name FROM jos3l_fwre_garage_type_translation AS tt WHERE tt.garage_type_id = p.garage_type_id AND lang = 'en-GB' LIMIT 1) AS _garage_type_name , (SELECT COUNT(*) FROM jos3l_fwre_property_agent AS pa WHERE pa.property_id = p.id) AS _agents_exist, '' AS _agents, '' AS _customfields, (SELECT COUNT(*) FROM `jos3l_fwre_property_customfield` AS pc WHERE pc.property_id = p.id AND pc.lang = 'en-GB') AS _customfields_exist, pt.builder AS _builder, (SELECT rt.builder FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _builder_eng_translation, (SELECT rt.builder FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.builder <> '' LIMIT 1) AS _builder_any_translation, pt.subdivision AS _subdivision, (SELECT rt.subdivision FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _subdivision_eng_translation, (SELECT rt.subdivision FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.subdivision <> '' LIMIT 1) AS _subdivision_any_translation, pt.school_district AS _school_district, (SELECT rt.school_district FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _school_district_eng_translation, (SELECT rt.school_district FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.school_district <> '' LIMIT 1) AS _school_district_any_translation, pt.neighborhood AS _neighborhood, (SELECT rt.neighborhood FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _neighborhood_eng_translation, (SELECT rt.neighborhood FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.neighborhood <> '' LIMIT 1) AS _neighborhood_any_translation, (SELECT name FROM jos3l_fwre_attic_translation AS at WHERE at.attic_id = p.attic_id AND lang = 'en-GB' LIMIT 1) AS _attic_name, (SELECT name FROM jos3l_fwre_basement_translation AS bt WHERE bt.basement_id = p.basement_id AND lang = 'en-GB' LIMIT 1) AS _basement_name, (SELECT name FROM jos3l_fwre_scope_of_work_translation AS st WHERE st.scope_of_work_id = p.scope_of_work_id AND lang = 'en-GB' LIMIT 1) AS _scope_of_work_name , (SELECT COUNT(*) FROM jos3l_fwre_favorites AS f WHERE f.property_id = p.id AND f.user_id = 0) AS _is_favorite , (SELECT COUNT(*) FROM jos3l_fwre_property_rooms AS pr WHERE pr.property_id = p.id) AS _rooms_exists , pt.open_house AS _open_house, (SELECT rt.open_house FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _open_house_eng_translation, (SELECT rt.open_house FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.open_house <> '' LIMIT 1) AS _open_house_any_translation , pt.meta_descr AS _meta_descr, (SELECT rt.meta_descr FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _meta_descr_eng_translation, (SELECT rt.meta_descr FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.meta_descr <> '' LIMIT 1) AS _meta_descr_any_translation, pt.meta_keys AS _meta_keys, (SELECT rt.meta_keys FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _meta_keys_eng_translation, (SELECT rt.meta_keys FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.meta_keys <> '' LIMIT 1) AS _meta_keys_any_translation , (SELECT name FROM jos3l_fwre_status_translation AS st WHERE st.status_id = p.status_id AND lang = 'en-GB' LIMIT 1) AS _status_name, (SELECT color FROM jos3l_fwre_status AS st WHERE st.id = p.status_id LIMIT 1) AS _status_color, (SELECT text_color FROM jos3l_fwre_status AS st WHERE st.id = p.status_id LIMIT 1) AS _status_text_color FROM jos3l_fwre_property AS p LEFT JOIN jos3l_fwre_property_translation AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) ORDER BY p.featured DESC, p.ordering LIMIT 240, 1535.96ms72.73KB/components/com_fwrealestate/models/search.php:292Copy
  • SELECT c.*, '' AS _type_name, '' AS _position_name, 0 AS _position_ordering, '' AS _values, 0 AS _tab_ordering, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.name <> '' LIMIT 1) AS _name_any_translation FROM `jos3l_fwre_customfield` AS c LEFT JOIN `jos3l_fwre_group` AS g ON g.id = c.group_id LEFT JOIN `jos3l_fwre_tab` AS t ON t.id = g.tab_id WHERE ( g.published = 1 AND t.published = 1 ) OR c.group_id IN (0, 1, 2) OR g.tab_id IN (0, 1, 2) OR c.group_id IS NULL OR g.tab_id IS NULL ORDER BY c.ordering197μs1.89KB/plugins/fwrealestate/customfields/customfields.php:1388Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_tab AS t ORDER BY ordering121μs2.05KB/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_group AS t ORDER BY ordering786μs880B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT c.*, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.`text` <> '' LIMIT 1) AS _name_any_translation FROM `jos3l_fwre_customfield_values` AS c WHERE c.customfield_id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14)108μs752B/plugins/fwrealestate/customfields/customfields.php:1421Copy
  • SELECT * FROM `jos3l_fwre_fields_access` WHERE property_id = 0103μs1008B/components/com_fwrealestate/helpers/fwrealestatefields.php:164Copy
  • SELECT property_id, `key`, `access` AS property_access FROM `jos3l_fwre_fields_access` WHERE property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019)411μs640B/components/com_fwrealestate/helpers/fwrealestatefields.php:188Copy
  • SELECT property_id, `image` FROM `jos3l_fwre_property_gallery` WHERE property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019) ORDER BY ordering, id4.27ms24.56KB/components/com_fwrealestate/models/search.php:303Copy
  • SELECT DISTINCT property_id, name FROM `jos3l_fwre_property_categories` AS pc, `jos3l_fwre_category_translation` AS ct WHERE ct.category_id = pc.category_id AND ct.lang = 'en-GB' AND pc.property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019)649μs832B/components/com_fwrealestate/models/search.php:310Copy
  • SELECT DISTINCT property_id, name FROM `jos3l_fwre_property_types` AS pc, `jos3l_fwre_property_type_translation` AS ct WHERE ct.property_type_id = pc.property_type_id AND ct.lang = 'en-GB' AND pc.property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019)727μs832B/components/com_fwrealestate/models/search.php:317Copy
  • SELECT pa.property_id, up.*, u.name AS _system_user_name, u.email AS _user_email, (SELECT att.name FROM `jos3l_fwre_agent_title_translation` AS att WHERE att.lang = 'en-GB' AND att.agent_title_id = pa.agent_title_id LIMIT 1) AS _title, prt.name AS _user_name, (SELECT tt.name FROM `jos3l_fwre_profile_translation` AS tt WHERE tt.user_id = u.id AND tt.lang = 'en-GB' LIMIT 1) AS _user_name_eng_translation, (SELECT tt.name FROM `jos3l_fwre_profile_translation` AS tt WHERE tt.user_id = u.id LIMIT 1) AS _user_name_any_translation, prt.company AS _company_name, prt.address AS _address, prt.details AS _details FROM `jos3l_fwre_property_agent` AS pa, `jos3l_users` AS u LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = u.id LEFT JOIN `jos3l_fwre_profile_translation` AS prt ON prt.user_id = u.id AND prt.lang = 'en-GB' WHERE pa.property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019) AND u.id = pa.user_id ORDER BY pa.ordering594μs2.73KB/plugins/fwrealestate/agents/agents.php:978Copy
  • SELECT cf.*, c.group_id, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.name <> '' LIMIT 1) AS _name_any_translation, CONCAT('customfields.', c.`alias`) AS `key` FROM `jos3l_fwre_property_customfield` AS cf, `jos3l_fwre_customfield` AS c WHERE c.id = cf.customfield_id AND cf.`lang` = 'en-GB' AND cf.property_id IN (30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019) ORDER BY c.ordering6.13ms19.83KB/plugins/fwrealestate/customfields/customfields.php:103Copy
  • SELECT COUNT(*) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))3.08ms536B/components/com_fwrealestate/models/search.php:345Copy
  • SELECT `element`, `enabled`, `folder` FROM `jos3l_extensions` WHERE `type` = 'plugin' AND `folder` IN ('fwrealestate', 'fwrealestatetmpl')179μs1KB/components/com_fwrealestate/helpers/helper.php:812Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any , (SELECT ttr.image FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS image FROM jos3l_fwre_status AS t ORDER BY name, eng, any141μs976B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos3l_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)250μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_dimension AS t ORDER BY name, eng, any113μs768B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos3l_modules` AS `m` LEFT JOIN `jos3l_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos3l_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.01ms1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT (SELECT MAX(p.bth) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_bth, (SELECT MAX(p.bdr) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_bdr, (SELECT MAX(p.numeric_price) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_price, (SELECT MAX(CASE WHEN p.living_area IS NOT NULL THEN p.living_area ELSE 0 END) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_area, (SELECT MAX(CASE WHEN p.lot_size IS NOT NULL THEN p.lot_size ELSE 0 END) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_size12.63ms3.25KB/modules/mod_fwre_search/helper.php:287Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_amenities AS t ORDER BY name, eng, any373μs688B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT t.id, (SELECT st.name FROM `jos3l_fwre_property_type_translation` AS st WHERE st.lang = 'en-GB' AND st.property_type_id = t.id LIMIT 1) AS property_type, (SELECT st.name FROM `jos3l_fwre_property_type_translation` AS st WHERE st.property_type_id = t.id LIMIT 1) AS property_type_any, (SELECT COUNT(*) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND EXISTS(SELECT * FROM `jos3l_fwre_property_types` AS pc WHERE pc.property_id = p.id AND pc.property_type_id = t.id)) AS qty FROM `jos3l_fwre_property_type` AS t WHERE EXISTS(SELECT * FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND EXISTS(SELECT * FROM `jos3l_fwre_property_types` AS pc WHERE pc.property_id = p.id AND pc.property_type_id = t.id)) ORDER BY property_type, property_type_any34.98ms720B/modules/mod_fwre_search/helper.php:485Copy
  • SELECT pc.category_id, (SELECT st.name FROM `jos3l_fwre_category_translation` AS st WHERE st.lang = 'en-GB' AND st.category_id = pc.category_id) AS category, (SELECT st.name FROM `jos3l_fwre_category_translation` AS st WHERE st.category_id = pc.category_id LIMIT 1) AS category_any, COUNT(*) AS qty FROM jos3l_fwre_property AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB', `jos3l_fwre_property_categories` AS pc WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND pc.property_id = p.id GROUP BY pc.category_id ORDER BY category24.47ms704B/modules/mod_fwre_search/helper.php:450Copy
  • SELECT bdr, COUNT(*) AS qty FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) GROUP BY bdr ORDER BY bdr3.66ms736B/modules/mod_fwre_search/helper.php:343Copy
  • SELECT bth, COUNT(*) AS qty FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) GROUP BY bth ORDER BY bth3.18ms1.06KB/modules/mod_fwre_search/helper.php:310Copy
  • SELECT * FROM `jos3l_nspro_lists` WHERE `state` = 1 ORDER BY `id`327μs1.28KB/components/com_nspro/models/nspro.php:28Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "1" ORDER BY `ordering` ASC225μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "2" ORDER BY `ordering` ASC259μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "0" ORDER BY `ordering` ASC167μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos3l_fields AS a LEFT JOIN `jos3l_languages` AS l ON l.lang_code = a.language LEFT JOIN jos3l_users AS uc ON uc.id=a.checked_out LEFT JOIN jos3l_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos3l_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos3l_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC2.24ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos3l_scheduler_tasks` AS `a` WHERE `a`.`state` = 1149μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = ?328μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos3l_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?995μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy