Debug Bar(errors: 0, warnings: 36, notices: 21, queries: 24, includes: 3, time: 166.03ms)▲

No errors

Warning: Constant DEBUGTHISPAGE already defined

search.php:3

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:90

Warning: Undefined variable $orderby

644ebb61f541f7b0f684a02f5c8cdd61882d7590.php:3

Warning: Undefined array key "orderby"

ba31f5bfd761a32bdd2ca049f32960455df1de30.php:175

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

Warning: Undefined variable $filter

nav-bar.php:368

Warning: Undefined variable $filter

nav-bar.php:485

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: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: 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: 24 queries in 122.48ms

#159.21ms

select text_key, value from c_dealer_site_texts where dealer_id = 544

#22.29ms


    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

#31.85ms


   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

#41.74ms


    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

#54.4ms


    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

#61.66ms


    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

#725.85ms


    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.dealer_id = 544 order by ifnull(a.revived_at , a.created_at) DESC
    LIMIT 0, 48

#80.58ms

SELECT FOUND_ROWS()

#92.45ms

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' 
ORDER BY mk.make;

#102.33ms


  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

#110.61ms


  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]

#120.58ms


  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]

#132.63ms

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

#142.28ms


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

#152.22ms


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

#162.17ms


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

#170.49ms

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]

#180.5ms


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]

#190.5ms


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]

#200.48ms


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]

#211.77ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit

#222.14ms


    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

#232.12ms


    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

#241.65ms

select show_legal_guarantee_notice from c_dealers where id = 544

Project: Modular DealersMemory: 5.44MBTime: 166.03ms

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

Used Car Search

Used Car Search

2024 Bentley Bentayga

Our Price

Monthly from

2022 Land Rover Defender

Our Price

Monthly from

2026 Leapmotor B05

Our Price

Monthly from

2011 Ariel Atom

Our Price

Monthly from

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 Mazda Demio

Our Price

Monthly from

2021 Mazda Demio

Our Price

Monthly from

2017 BMW 3 Series

Our Price

Monthly from

2021 Lexus UX 250H

Our Price

Monthly from

2020 Toyota C-HR

Our Price

Monthly from

2023 Toyota Hilux

Our Price

Monthly from

2021 Lexus UX 250H

Our Price

Monthly from

2019 BMW 3 Series

Our Price

Monthly from

2018 BMW 3 Series

Our Price

Monthly from

2022 Mitsubishi Mirage

Our Price

Monthly from

2014 BMW 116

Our Price

Monthly from

2022 Mercedes-Benz EQB

Our Price

Monthly from

2016 Hyundai Tucson

Our Price

Monthly from

2016 Hyundai Tucson

Our Price

Monthly from

2016 BMW 5 Series

Our Price

Monthly from

2014 Peugeot 208

Our Price

Monthly from

2014 Peugeot 208

Our Price

Monthly from

2022 Hyundai Tucson

Our Price

Monthly from