Debug Bar(errors: 0, warnings: 34, notices: 40, queries: 22, includes: 2, time: 201.29ms)▲

No errors

Warning: Constant DEBUGTHISPAGE already defined

search-premium.php:3

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:89

Warning: Undefined variable $orderby

644ebb61f541f7b0f684a02f5c8cdd61882d7590.php:3

Warning: Undefined array key "orderby"

43bd86a83526dc3bdd9fd208723dd50a730ce9a8.php:174

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 array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

Warning: Undefined array key "orderby"

nav-bar.php:590

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 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:43

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:1080

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

mtd.inc:1080

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: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Total: 22 queries in 134.53ms

#171.13ms

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

#29.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

#33.09ms


   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

#45.51ms


    select
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_hours h
    where h.dealer_id = 544
    order by 1

#52.25ms


    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

#66.18ms


    SELECT SQL_CALC_FOUND_ROWS
        a.id,
        a.s3_image,
        a.description,
        a.price,
        a.previous_price,
        CEIL(fin.monthly_payments) AS monthly_payments,
        fin.apr AS apr,
        a.reg_year,
        IF(IFNULL(a.make_text, '') != '', a.make_text, mk.make) AS make,
        IF(IFNULL(a.model_text, '') != '', a.model_text, md.model) AS model,
        a.variant,
        a.owners,
        a.test_due_date,
        a.mileage,
        a.kilometres,
        a.updated_at,
        a.engine_cc,
        a.doors,
        a.seats,
        a.youtube_id,
        a.video_type,
        a.video_id,
        a.s3_image,
        CEIL(a.finance_price_per_month_pcp) AS finance_price_per_month_pcp,
        a.key_location,
        CEIL(a.finance_price_per_month) AS finance_price_per_month,
        a.fuel_cons_combined,
        DATE_FORMAT(a.expires_at, '%r on %d/%m/%Y') AS expiry_date,
        a.external_ad_id,
        ai.id AS image_id,
        ai.template_id,
        f.fuel_type,
        t.transmission_type,
        b.body_type,
        c.rgb_hex,
        c.colour,
        r.region,
        l.address1,
        l.address2,
        l.address3,
        d.location_name,
        ct.display as cylinders, 
        a.dealer_id AS ad_dealer_id,
        IF(IFNULL(reservation_id, 0), 1, 0) AS is_reserved,
        fin.id AS finid,
        EXISTS (SELECT 1 FROM c_ad_extra_properties aep WHERE aep.ad_id = a.id) AS has_extras,
        (SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
        
    
    FROM c_ads a
    INNER JOIN c_dealers d ON a.dealer_id = d.id
    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_finance_calc_results fin ON a.id = fin.ad_id
    LEFT JOIN c_groups g ON d.group_id = g.id
    LEFT JOIN c_transmission_types t ON a.transmission_type_id = t.id
    LEFT JOIN c_fuel_types f ON a.fuel_type_id = f.id
    LEFT JOIN c_ad_images ai ON a.main_image_id = ai.id
    LEFT JOIN c_body_types b ON a.body_type_id = b.id
    LEFT JOIN c_colours c ON a.colour_id = c.id
    LEFT JOIN c_dealer_addresses l ON a.dealer_id = l.dealer_id
    left join c_cylinder_types ct on a.cylinder_type_id = ct.id 
    INNER JOIN c_country_regions r ON l.region_id = r.id
     WHERE ( fin.deposit_and_trade_in is null or (fin.is_default and fin.is_default_term) )
    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  a.price > 30000 
    AND  a.dealer_id = 544 order by ifnull(a.revived_at , a.created_at) DESC
    LIMIT 0, 48

#70.27ms

SELECT FOUND_ROWS()

#83.68ms

SELECT DISTINCT
mk.make,
mk.id AS make_id
FROM c_ads a
INNER JOIN c_makes mk ON a.make_id = mk.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' 
and a.price > 30000 
ORDER BY mk.make;

#91.31ms


  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]

#101.29ms


  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]

#111.26ms


  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]

#129.74ms

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
     and a.price > 30000  
    GROUP BY mk.id, mk.make
    order by mk.make

#133.52ms


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.price > 30000   
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

#143.6ms


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
 and a.price > 30000  
group by t.id,t.body_type
order by t.body_type

#153.46ms


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
 and a.price > 30000  
group by t.id,t.transmission_type
order by t.transmission_type

#161.38ms

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
     and a.price > 30000  
    GROUP BY mk.id, mk.make
    order by mk.make [CACHED]

#171.21ms


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
 and a.price > 30000  
group by t.id,t.body_type
order by t.body_type
   [CACHED]

#181.19ms


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.price > 30000   
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]

#191.25ms


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
 and a.price > 30000  
group by t.id,t.transmission_type
order by t.transmission_type
   [CACHED]

#201.24ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#211.21ms


    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]

#221.2ms


    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]

Project: Modular DealersMemory: 5.9MBTime: 201.29ms

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

Premium and Luxury Cars

Premium and Luxury Cars

2017 Alfa Romeo Giulia

Was €37,000

Monthly from

2016 Hyundai Tucson

Our Price

Monthly from

2016 Hyundai Tucson

Our Price

Monthly from

2019 BMW 3 Series

Our Price

Monthly from

2021 Lexus UX 250H

Our Price

Monthly from

2019 BMW 3 Series

Our Price

Monthly from

2016 BMW 5 Series

Our Price

Monthly from

2017 Alfa Romeo Giulia

Was €37,000

Monthly from

2024 Audi A7

Our Price

Monthly from

2017 Alfa Romeo Giulia

Our Price

Monthly from

Get in Touch

Find us

Sales Opening Hours

Aftersales Opening Hours & Contact