2021 Mazda Demio

2021 Mazda Demio

1.5 S BUSINESS USE PACKAGE AUTO.

2021 Mazda Demio

2021 Mazda Demio

2021 Mazda Demio

2021 Mazda Demio

Fuel Type

Petrol

Bodytype

Hatchback

Year

2021

Mileage

44,740 km / 27,801 mi

Transmission

Automatic

Colour

Wine

Make: Mazda
Model: Demio
Year: 2021
Price: €16,495
Monthly Price From: €298
Mileage: 44,740 km / 27,801 mi
Gearbox: Automatic
Fuel Type: Petrol
Body Type: Hatchback
Colour: Wine
Last Updated: 27/08/2026

More Information

Welcome to AutoXpress.ie – Luxury for Less! Please Note! This Vehicle is in Transit and will be Available Soon. Introducing the 2021 Mazda Demio 1.5 Automatic – a perfect blend of smart design, ... fuel efficiency, and everyday practicality. Ideal for city driving or weekend getaways, this compact hatchback offers low mileage, modern tech, and Japanese reliability in one sleek package. Why Choose AutoXpress.ie? Dealer warranty 500+ Quality Used Cars Fully Serviced & Inspected Premium Warranty Options We Accept Trade-Ins Flexible Finance Available Key Vehicle Details: ? Year: 2021 ? Mileage: 44,739 miles ? Transmission: Automatic ? Fuel Type: Petrol ? NCT Valid Until: 03/2028 ? Engine: 1.5L Top Features: ?Reversing Camera ? Multimedia Screen ? Phone Connectivity ? Air Conditioning ? USB/AUX Inputs Traction Control ? Driving Modes ? Electric Windows & Mirrors Finance this car from as low as €X/month! ? Competitive trade-in deals and flexible credit options available. ? Call us in Limerick at 061-446033 or Galway at 091-335696 for more details or to schedule a test drive. ? Visit AutoXpress.ie Drive away your next car with confidence — 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: 20, queries: 28, includes: 2, time: 113.88ms)▲

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: 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 84.29ms

#158.43ms

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

#20.61ms


    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.48ms


   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.44ms


    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.49ms


    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.89ms


    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

#73.26ms


      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 = 363187
        and a.deleted_at is null
        and a.paused_at is null
        and a.status = 'live'
       and  a.dealer_id = 544 
      limit 1

#81.76ms

select max(term) from c_ad_finance_calc_results where ad_id = 363187

#91.74ms

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

#101.9ms

select min(term) from c_ad_finance_calc_results where ad_id = 363187

#111.63ms


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

#121.88ms


    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 = 363187
      and ai.deleted_at is null
    order by ai.sort_key

#131.85ms


      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 = 363187
      and is_default_term
      order by is_dealer_default desc, deposit_and_trade_in limit 1

#140.43ms


  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.61ms


      select a.finance_price_per_month from c_ads a where id = 363187

#160.46ms

	
          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 [CACHED]

#170.43ms


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

#180.51ms


  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.46ms


  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.47ms


  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.48ms

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.41ms


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.41ms


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.45ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#260.46ms


    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.47ms


    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.3MBTime: 113.88ms