2019 BMW 3 Series

2019 BMW 3 Series

320D XDRIVE 4WD Leather Pack Automatic

2019 BMW 3 Series

2019 BMW 3 Series

2019 BMW 3 Series

2019 BMW 3 Series

Fuel Type

Diesel

Bodytype

Saloon

Year

2019

Mileage

39,769 km / 24,712 mi

Transmission

Automatic

Colour

White

Make: BMW
Model: 3 Series
Year: 2019
Price: €30,495
Monthly Price From: €550
Mileage: 39,769 km / 24,712 mi
Gearbox: Automatic
Fuel Type: Diesel
Body Type: Saloon
Colour: White
Last Updated: 27/08/2026

More Information

Welcome to AutoXpress.ie – Luxury for Less! ? Introducing our 2019 (192) BMW 320d xDrive 4WD Automatic – a masterclass in dynamic performance, all-weather capability, and premium luxury. With a p ... owerful yet efficient 2.0L diesel engine and BMW's intelligent xDrive All-Wheel Drive system, this 3 Series offers unparalleled grip and a thrilling driving experience in all conditions. ? Please Note: This vehicle is in transit and will be available soon! Why Choose AutoXpress.ie? 6 Months Premium Warranty Included – Drive with complete peace of mind. All vehicles come fully serviced and valeted. Nationwide delivery available. Trade-ins welcome. In-house same-day finance approval. ? Finance Options We offer flexible finance solutions tailored to your budget – fast approval guaranteed! Key Vehicle Details: ? Year: 2019 (192) ? Model: BMW 320d xDrive 4WD ? Transmission: Automatic ? Mileage: 39,768 miles ? Fuel Type: Diesel ? NCT Valid Until: 03/2028 Top Features: Performance & Design: xDrive All-Wheel Drive System – For superior traction and stability on all roads. Driving Experience Control (Sport/Comfort/Eco Pro) – Tailor your driving style to your mood. Alloy Wheels & Black Interior Leather Trim – A sleek and modern aesthetic inside and out. Technology & Infotainment: BMW Digital Live Cockpit & Touchscreen Multimedia System – A stunning digital dashboard and central screen for all your needs. Push Start Button & USB Type-C Charging Ports – Modern convenience and high-speed charging. Safety & Assistance: Reversing Camera & Front & Rear Parking Sensors – Makes parking and maneuvering effortless and safe. Lane Departure Warning & Front Assist (City Braking) – Advanced driver-assistance features for added peace of mind. Automatic Headlights & ISOFIX Child Seat Mounts – Essential features for safety and convenience. Luxury & Convenience: Automatic Climate Control & Cruise Control – Ensures a comfortable cabin and relaxed long journeys. Heated & Electric Folding Mirrors & Electric Windows – Convenient power operation and quick demisting. Electric Handbrake with Auto Hold – Reduces driver fatigue in stop-start traffic. Multifunction Steering Wheel & Central Locking – Puts controls at your fingertips for calls and media. ? Contact Us Today: ? Call us in Limerick at 061-446033 or Galway at 091-335696 for more details or to schedule a test drive. ? Visit www.autoxpress.ie to explore finance options and secure this fantastic BMW today! ? Experience the ultimate driving machine – only at AutoXpress.ie!

Contact Information

Phone

Sales:

Business Address

Milltown Lane, Rathnew,
Co. Wicklow,

Sales Opening Hours

Mon - Sun:

Closed

Aftersales Opening Hours & Contact

Mon:	9:30am - 4:30pm
Tue - Thu:	9:30am - 5:30pm
Fri:	9:30am - 4:30pm
Sat - Sun:	Closed

Aftersales is Closed for Lunch from 1pm to 2pm.
Aftersales does not operate on any Bank Holidays.

Debug Bar(errors: 0, warnings: 69, notices: 41, queries: 28, includes: 2, time: 135.15ms)▲

No errors

Warning: Undefined array key 1

e144146edecc31057ee7f47faad3df90e2bf1088.php:68

Warning: Undefined array key 3

e144146edecc31057ee7f47faad3df90e2bf1088.php:434

Warning: Undefined array key 8

opening-hours.php:57

Warning: Undefined array key 1

130b35c85b854d0d8de6fc3f8ab0675bdbdb62c8.php:13

Warning: Undefined array key 2

nav-bar.php:13

Warning: Undefined variable $is_new_cars_page

nav-bar.php:119

Warning: Undefined array key 3

nav-bar.php:330

Warning: Undefined variable $filter

nav-bar.php:485

Warning: Undefined array key 1

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:11

Warning: Undefined array key 2

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:12

Warning: Undefined variable $whatsapp_phone

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Undefined array key 3

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 4

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 5

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 8

opening-hours.php:57

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:327

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:327

Deprecated: mtd_makes(): Optional parameter $filter declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1127

Deprecated: mtd_makes(): Optional parameter $extra_filters declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1127

Deprecated: Jenssegers\Blade\Blade::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Blade.php:34

Deprecated: Illuminate\Container\Container::beforeResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1114

Deprecated: Illuminate\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1134

Deprecated: Illuminate\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1154

Deprecated: Illuminate\Container\Container::setInstance(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1393

Deprecated: Illuminate\Contracts\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:173

Deprecated: Illuminate\Contracts\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:182

Deprecated: Illuminate\View\FileViewFinder::__construct(): Implicitly marking parameter $extensions as nullable is deprecated, the explicit nullable type must be used instead

FileViewFinder.php:53

Deprecated: Illuminate\Events\Dispatcher::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Dispatcher.php:65

Deprecated: Illuminate\Support\Str::createUuidsUsing(): Implicitly marking parameter $factory as nullable is deprecated, the explicit nullable type must be used instead

Str.php:1007

Deprecated: Illuminate\View\View::render(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

View.php:88

Deprecated: Illuminate\Support\Arr::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:183

Deprecated: Illuminate\Support\Arr::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:212

Deprecated: Illuminate\View\Engines\CompilerEngine::__construct(): Implicitly marking parameter $files as nullable is deprecated, the explicit nullable type must be used instead

CompilerEngine.php:33

Deprecated: Illuminate\Support\Collection::filter(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:355

Deprecated: Illuminate\Support\Collection::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:371

Deprecated: Illuminate\Support\Collection::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:668

Deprecated: Illuminate\Support\Traits\EnumeratesValues::times(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:144

Deprecated: Illuminate\Support\Traits\EnumeratesValues::when(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:475

Deprecated: Illuminate\Support\Traits\EnumeratesValues::when(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:475

Deprecated: Illuminate\Support\Traits\EnumeratesValues::whenEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:497

Deprecated: Illuminate\Support\Traits\EnumeratesValues::whenNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:509

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unless(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:522

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unlessEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:534

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unlessNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:546

Deprecated: Illuminate\Support\Enumerable::times(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:28

Deprecated: Illuminate\Support\Enumerable::filter(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:268

Deprecated: Illuminate\Support\Enumerable::when(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:278

Deprecated: Illuminate\Support\Enumerable::whenEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:287

Deprecated: Illuminate\Support\Enumerable::whenNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:296

Deprecated: Illuminate\Support\Enumerable::unless(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:306

Deprecated: Illuminate\Support\Enumerable::unlessEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:315

Deprecated: Illuminate\Support\Enumerable::unlessNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:324

Deprecated: Illuminate\Support\Enumerable::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:432

Deprecated: Illuminate\Support\Enumerable::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:555

Deprecated: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated

mtd.inc:1213

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Total: 28 queries in 91.82ms

#166.77ms

select text_key, value from c_dealer_site_texts where dealer_id = 544 [CACHED]

#20.57ms


    select
      d.display_name,
      d.id,
      d.use_display_name_for_consent,
      d.group_id,
      g.name as group_name,
      d.facebook_id,
      d.facebook_url,
      d.youtube_id,
      d.youtube_link,
      d.twitter_link,
      d.instagram_link,
      d.linkedin_link,
      d.tiktok_url,
      d.is_simi,
  	  d.use_km,
      d.email_enquiries,
      d.opening_hours_extra_text,
      d.reservation_days,
      d.reservation_option,
      d.finance_default_deposit_pct,
      d.use_google_reviews,
      d.google_reviews_link,
      d.google_reviews_avg_rating,
      d.google_reviews_total,
      d.finance_start_with_personal_details,
  	  d.principal,
  	  d.principal_title,
      d.slug,
      d.allow_html_description,
      d.finance_default_hp_rate,
      d.finance_default_pcp_rate,
      d.payment_provider,
      d.payment_secret_key_enc,
      d.square_access_token_enc,
      d.square_location_id,
      da.address1,
      da.address2,
      da.address3,
      da.address4,
      da.address5,
      da.postcode,
      da.map_lat,
      da.map_long,
      da.map_zoom,
      r.country_code,
      r.region,
      if (d.reservation_new_option = 0, null,  rp.cost_to_reserve) as cost_to_reserve_new
    from c_dealers d
    left join c_groups g on g.id = d.group_id
    left join c_dealer_addresses da on da.dealer_id = d.id
    left join c_country_regions r on da.region_id = r.id
    left join c_reservation_prices rp on d.reservation_new_price_id = rp.id
    where d.id = 544
   [CACHED]

#30.51ms


   select
     name,
     phone,
     email,
     is_primary_contact
   from c_dealer_website_contacts
   where dealer_id = 544
    and hide_on_website = 0
   order by sort_key
   [CACHED]

#40.48ms


    select
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_hours h
    where h.dealer_id = 544
    and h.department_id is null
    order by 1
   [CACHED]

#50.57ms


    select
    d.slug,
    d.name,
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_departments d
    left join c_dealer_hours h on h.department_id = d.id
    where d.dealer_id = 544
    order by d.sort_order, d.id, h.dow
   [CACHED]

#61.49ms


    select
    a.id,
    a.s3_image,
    a.main_image_id,
    ai.template_id,
    a.reg_year,
    a.price,
    a.mileage,
    mk.make,
    md.model
    from c_ads a
    inner join c_makes mk on a.make_id = mk.id
    inner join c_models md on a.model_id = md.id
    left join c_ad_images ai on a.main_image_id = ai.id
    where dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      and is_dealer_special = 1

#72.94ms


      select
        a.id,
        a.s3_image,
        a.is_commercial,
        a.external_ad_id,
        a.mileage,
        a.kilometres,
        a.odo_units,
        a.make_id,
        a.model_id,
        a.make_text,
        a.model_text,
        a.reg_year,
        a.price,
		    a.previous_price,
        a.trade_in_price,
        /* a.vrt, */
        /* round(a.vrt_estimate) as vrt_estimate, */
      /* round(a.omsp_for_vrt) as omsp_for_vrt, */
        a.description,
        a.dealer_id,
        a.created_at,
        date_format(a.created_at, '%Y%m%d%H%i%s') as creation_date_fmt,
        date_format(a.expires_at, '%Y%m%d%H%i%s') as expiry_date_fmt,
        /* using dealer updated date not ad updated date */
        d.stock_updated_at as updated_at,
        a.main_image_id,
        ai.template_id as main_template_id,
        /* ifnull(a.email_enquiries_p,0) as email_enquiries_p, */
        d.email,
        a.engine_cc,
        a.hide_extra_info_on_dealer_website,
        /* a.review_id, */
        r.region,
        mk.make,
        mk.category_id,
        md.model,
        /* a.commercial_p, */
        d.display_name,
        d.phone,
        /* d.email_enquiries_p as dealer_enquiries_p, */
        d.group_id,
        /* d.show_web_link_p, */
        d.web,
        /* d.disable_map_p, */
        /* d.simi_p, */
        d.opening_hours_extra_text,
        da.address1,
        da.address2,
        da.address3,
        da.address4,
        da.address5,
        da.postcode,
        da.map_lat,
        da.map_long,
        /* d.youtube_id AS dealer_youtube_id, */
        d.reservation_option as dealer_reservation_option,
        rpd.cost_to_reserve as dealer_cost_to_reserve,
        a.reservation_option as ad_reservation_option,
        rpa.cost_to_reserve as ad_cost_to_reserve,
        a.fuel_type_id,
        fu.fuel_type,
        a.colour_id,
        cl.colour,
        a.colour_description,
        a.body_type_id,
        bd.body_type,
        a.variant,
        a.owners,
        a.transmission_type_id,
        tr.transmission_type,
        a.reg_number,
        /* ifnull(a.contact_name_public_p,0) as contact_name_public_p, */
        /* a.contact_name, */
        if(a.tax_due_date > now(), a.tax_due_date, null) as tax_due_date,
        if(a.test_due_date > now(), a.test_due_date, null) as test_due_date,
        a.co2,
        a.max_power_bhp,
        a.road_tax_cost,
        a.fuel_cons_combined,
        a.doors,
        a.seats,
        a.stock_number,
        d.location_name,
        ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
        a.accel_0_to_62,
        /* a.email_public_p, */
        /* a.phone_no_public_p, */
        a.youtube_id,
        a.video_type,
        a.video_id,
        a.finance_flat_rate_apr,
        a.finance_option,
        a.finance_max_term,
        a.finance_max_deposit,
        if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
        aei.max_power_hp,
        aei.max_power_revs,
        aei.max_torque_nm,
        aei.max_torque_revs,
        aei.fuel_cons_urban,
        aei.fuel_cons_extra_urban,
        aei.max_speed_mph,
        aei.ncap_overall,
        aei.ncap_adult_occupant,
        aei.ncap_child_occupant,
        aei.ncap_adult_pct,
        aei.ncap_child_pct,
        aei.gross_weight_kg,
        aei.unladen_weight_kg,
        aei.wheelbase_mm,
        fbr.balance_remaining_over,
        fbr.balance_remaining_under,
        fbr.over_apr,
        fbr.under_apr,
        a.is_dealer_special,
        a.interior_360_url,
        a.exterior_360_url,
        w.period_months,
        d.use_custom_warranty,
        wt.title as warranty_term,
        a.key_location,
        a.grade,
        a.eta,
        a.turntable_images_count,
        a.licence_type,
        a.colour_interior_description,
        if (d.allow_public_vins = 1, a.vin, null) as vin_encrypted,
        ct.display as cylinders, 
        finoff.label as finance_offer
        /* ad extra info in here if needed */
      from
        c_ads a
      inner join c_models md on a.model_id = md.id
      inner join c_makes mk on a.make_id = mk.id
      left join c_ad_extra_info aei on a.id = aei.ad_id
      left join c_ad_images ai on a.main_image_id = ai.id
      left join c_dealers d on a.dealer_id = d.id
      left join c_dealer_addresses da on d.id = da.dealer_id
      left join c_country_regions r on d.region_id = r.id
      left join c_fuel_types fu on a.fuel_type_id = fu.id
      left join c_colours cl on a.colour_id = cl.id
      left join c_body_types bd on a.body_type_id = bd.id
      left join c_transmission_types tr on a.transmission_type_id = tr.id
      left join c_ad_finance_balance_rates fbr on a.id = fbr.ad_id
      left join c_reservation_prices rpd on d.reservation_price_id = rpd.id
      left join c_reservation_prices rpa on a.reservation_price_id = rpa.id
      left join c_ad_warranties w on a.warranty_id = w.id
      left join c_warranty_terms wt on a.warranty_term_id = wt.id
      left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
      left join c_dealer_finance_offers finoff on a.finance_offer_id = finoff.id
      where a.id = 363189
        and a.deleted_at is null
        and a.paused_at is null
        and a.status = 'live'
       and  a.dealer_id = 544 
      limit 1

#81.65ms

select max(term) from c_ad_finance_calc_results where ad_id = 363189

#91.41ms

select f.deposit_and_trade_in from c_ad_finance_calc_results f where f.ad_id = 363189 order by f.deposit_and_trade_in asc limit 1

#101.48ms

select min(term) from c_ad_finance_calc_results where ad_id = 363189

#111.34ms


      select name, value
      from c_ad_extra_properties aep
      where aep.ad_id = 363189

#121.55ms


    select
      ai.id as image_id,
      ai.template_id,
      a.dealer_id as ad_dealer_id,
      a.main_image_id
    from c_ad_images ai
    inner join c_ads a on a.id = ai.ad_id
    where a.id = 363189
      and ai.deleted_at is null
    order by ai.sort_key

#131.74ms


      select
        ceil(price) as price,
        ceil(deposit_and_trade_in) as deposit_and_trade_in,
        term,
        ceil(loan_amount) as loan_amount,
        apr,
        irr,
        ceil(monthly_payments) as monthly_payments,
        ceil(total_cost_of_credit) as total_cost_of_credit,
        ceil(documentation_fee) as documentation_fee,
        ceil(completion_fee) as completion_fee,
        reg_year
      from c_ad_finance_calc_results
      where ad_id = 363189
      and is_default_term
      order by is_dealer_default desc, deposit_and_trade_in limit 1

#140.52ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#151.37ms


      select a.finance_price_per_month from c_ads a where id = 363189

#161.39ms

	
          SELECT	
            r.reviewer_name,	
            r.review,	
            date_format(ifnull(r.updated_at, r.created_at), '%d %b %Y') as date,	
            r.reviewer_location,	
            r.rating	
          FROM c_dealer_reviews r	
          WHERE status = 'live' 	
          AND r.dealer_id = '544'  	
          ORDER BY r.created_at DESC limit 3

#170.61ms


    SELECT
      id,
      COUNT(rating) total_num,
      SUM(rating) total_sum
    FROM c_dealer_reviews
    WHERE STATUS = 'live'
      AND dealer_id = 544 [CACHED]

#180.74ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#190.57ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#200.45ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#210.44ms

select -- mtd_makes 544
    mk.id, mk.make 
    from c_makes mk
    inner join c_ads a on a.make_id = mk.id
    inner join c_dealers d on a.dealer_id = d.id
    where  a.dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
    
    GROUP BY mk.id, mk.make
    order by mk.make [CACHED]

#220.42ms


select -- mtd_body_types 544
t.id,t.body_type
from c_body_types t
inner join c_ads a on a.body_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id
 
  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.body_type
order by t.body_type
   [CACHED]

#230.44ms


select -- mtd_fuel_types 544
t.id,t.fuel_type
from c_fuel_types t
inner join c_ads a on a.fuel_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
 where  a.dealer_id = 544
  
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.fuel_type
order by t.sort_key
 [CACHED]

#240.44ms


select -- mtd_transmission_types 544
t.id,t.transmission_type
from c_transmission_types t
inner join c_ads a on a.transmission_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id 

  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.transmission_type
order by t.transmission_type
   [CACHED]

#250.49ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#260.49ms


    SELECT max(price)
    FROM c_ads a
    INNER JOIN c_dealers d on a.dealer_id = d.id
    
    WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      AND  a.dealer_id = 544 [CACHED]

#270.49ms


    SELECT min(price)
    FROM c_ads a
    INNER JOIN c_dealers d on a.dealer_id = d.id
    
    WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      AND  a.dealer_id = 544 [CACHED]

#280.46ms

select show_legal_guarantee_notice from c_dealers where id = 544 [CACHED]

Project: Modular DealersMemory: 5.92MBTime: 135.15ms