Debug Bar(errors: 0, warnings: 57, notices: 21, queries: 20, includes: 3, time: 119.58ms)▲

No errors

Warning: Constant DEBUGTHISPAGE already defined

search.php:2

Warning: Undefined property: stdClass::$address1

mtd.inc:276

Warning: Undefined property: stdClass::$address2

mtd.inc:277

Warning: Undefined property: stdClass::$address3

mtd.inc:280

Warning: Undefined property: stdClass::$address4

mtd.inc:283

Warning: Undefined property: stdClass::$address5

mtd.inc:286

Warning: Undefined property: stdClass::$postcode

mtd.inc:297

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:84

Warning: Undefined variable $orderby

b43b740a8d4431f103e89c393629621d89ff09cd.php:3

Warning: Array to string conversion

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:144

Warning: Undefined array key "orderby"

5e5694ec564ed995a5ad0a502bfe812e6149e688.php:145

Warning: Undefined property: stdClass::$address1

mtd.inc:276

Warning: Undefined property: stdClass::$address2

mtd.inc:277

Warning: Undefined property: stdClass::$address3

mtd.inc:280

Warning: Undefined property: stdClass::$address4

mtd.inc:283

Warning: Undefined property: stdClass::$address5

mtd.inc:286

Warning: Undefined property: stdClass::$postcode

mtd.inc:297

Warning: Undefined array key 1

5cdf59faf7e307af9590b3f880c63627a9be50c4.php:13

Warning: Undefined property: stdClass::$other_title_tag

05f98c96897194fb86a80207d584ddf4bd8af756.php:12

Warning: Undefined property: stdClass::$other_meta_desc

05f98c96897194fb86a80207d584ddf4bd8af756.php:21

Warning: Undefined property: stdClass::$address1

mtd.inc:276

Warning: Undefined property: stdClass::$address2

mtd.inc:277

Warning: Undefined property: stdClass::$address3

mtd.inc:280

Warning: Undefined property: stdClass::$address4

mtd.inc:283

Warning: Undefined property: stdClass::$address5

mtd.inc:286

Warning: Undefined property: stdClass::$postcode

mtd.inc:297

Warning: Undefined array key 1

nav-bar.php:12

Warning: Undefined array key 2

nav-bar.php:13

Warning: Undefined variable $is_new_cars_page

nav-bar.php:154

Warning: Undefined variable $filter

nav-bar.php:400

Warning: Undefined variable $filter

nav-bar.php:446

Warning: Undefined variable $filter

nav-bar.php:466

Warning: Undefined variable $filter

nav-bar.php:485

Warning: Undefined variable $filter

nav-bar.php:534

Warning: Undefined variable $filter

nav-bar.php:579

Warning: Undefined variable $filter

nav-bar.php:598

Warning: Undefined variable $filter

nav-bar.php:617

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key "orderby"

nav-bar.php:649

Warning: Undefined array key 1

c93092cbfa629bc73632e690058f2a27e6e6e238.php:11

Warning: Undefined array key 2

c93092cbfa629bc73632e690058f2a27e6e6e238.php:12

Warning: Undefined variable $whatsapp_phone

c93092cbfa629bc73632e690058f2a27e6e6e238.php:13

Warning: Undefined array key 3

c93092cbfa629bc73632e690058f2a27e6e6e238.php:99

Warning: Undefined array key 8

opening-hours.php:43

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

db.inc:310

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

db.inc:310

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

mtd.inc:1041

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

mtd.inc:1041

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

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

mtd.inc:1127

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

c93092cbfa629bc73632e690058f2a27e6e6e238.php:13

Total: 20 queries in 86.03ms

#161.09ms


    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]

#20.99ms


   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]

#31.21ms


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

#40.97ms


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

#57.48ms


    SELECT SQL_CALC_FOUND_ROWS
        a.id,
        a.s3_image,
        a.description,
        a.price,
        a.previous_price,
        CEIL(fin.monthly_payments) AS monthly_payments,
        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.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,
        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
    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  f.fuel_type = "Electric" 
    AND  a.dealer_id = 544 order by (ifnull(a.price,0)=0),a.price DESC
    LIMIT 0, 12

#60.3ms

SELECT FOUND_ROWS()

#71.01ms

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

#81.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 = 'boc2'
  order by b.id
  limit 1 [CACHED]

#90.95ms


  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 = 'boc2'
  order by b.id
  limit 1 [CACHED]

#100.97ms


  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 = 'boc2'
  order by b.id
  limit 1 [CACHED]

#110.97ms

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]

#120.94ms


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]

#130.98ms


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]

#140.94ms


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]

#150.96ms

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]

#160.94ms


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]

#170.94ms


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]

#180.91ms


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]

#190.91ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#201.04ms


    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]

Memory: 5.29MBTime: 119.58ms

Mon - Fri:	8.30am - 5.00pm
Sat:	Closed
Sun:	Closed

Used Car Search

Used Car Search

2016 Hyundai Tucson

Our Price

€23,500

Monthly from

2016 Hyundai Tucson

Our Price

€23,500

Monthly from

2022 Mercedes-Benz EQB

Our Price

POA

Monthly from

Contact Details

Sales Opening Hours

Service Opening Hours

Mercedes-benz Social Media

SEAT Social Media