Használt autók

array(1) { [0]=> string(0) "" }
(default) 17 queries took 257 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Online`.`user_id` FROM `hyundai60_hu`.`studio_onlines` AS `Online` LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Online`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_groups` AS `Group` ON (`Online`.`group_id` = `Group`.`id`) WHERE `last_seen` <= '2018-05-23 05:47:04'001
2SELECT `Online`.`session`, `Online`.`user_id`, `Online`.`group_id`, `Online`.`last_seen`, `Online`.`url`, `Online`.`ip`, `Online`.`created`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`fullname`, `User`.`firstname`, `User`.`lastname`, `User`.`avatar`, `User`.`content_count`, `User`.`facebook_id`, `User`.`google_id`, `User`.`active`, `User`.`activation_code`, `User`.`password_reset`, `User`.`lastseen`, `User`.`deleted`, `User`.`deleted_date`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `hyundai60_hu`.`studio_onlines` AS `Online` LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Online`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_groups` AS `Group` ON (`Online`.`group_id` = `Group`.`id`) WHERE `Online`.`user_id` = 'gc8v4bn3mmg69vumb8lqag4jo6' LIMIT 1000
3SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'gc8v4bn3mmg69vumb8lqag4jo6'110
4SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'gc8v4bn3mmg69vumb8lqag4jo6'110
5INSERT INTO `hyundai60_hu`.`studio_onlines` (`session`, `user_id`, `group_id`, `last_seen`, `ip`, `url`, `created`) VALUES ('gc8v4bn3mmg69vumb8lqag4jo6', 'gc8v4bn3mmg69vumb8lqag4jo6', 0, '2018-05-23 06:47:04', '23.20.7.34', '/hu/hasznaltauto', '2018-05-23 06:47:04')11253
6SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
7SELECT `WebshopOption`.`id`, `WebshopOption`.`key`, `WebshopOption`.`name`, `WebshopOption`.`value`, `WebshopOption`.`long`, `WebshopOption`.`deleted`, `WebshopOption`.`created`, `WebshopOption`.`modified` FROM `hyundai60_hu`.`studio_webshop_options` AS `WebshopOption` WHERE `WebshopOption`.`deleted` != 1000
8SELECT `WebshopSearchableProperty`.`id`, `WebshopSearchableProperty`.`name`, `WebshopSearchableProperty`.`isfixed`, `WebshopSearchableProperty`.`isnumeric`, `WebshopSearchableProperty`.`searchtype`, `WebshopSearchableProperty`.`searchmultiple`, `WebshopSearchableProperty`.`emptyinresult` FROM `hyundai60_hu`.`studio_webshop_properties` AS `WebshopSearchableProperty` WHERE `searchable` = 1000
9SELECT `WebshopCategory`.`id`, `WebshopCategory`.`name`, `WebshopCategory`.`description`, `WebshopCategory`.`seourl`, `WebshopCategory`.`picture`, `WebshopCategory`.`parent_id`, `WebshopCategory`.`lft`, `WebshopCategory`.`rght`, `WebshopCategory`.`cached_in_element`, `WebshopCategory`.`webshop_product_count`, `WebshopCategory`.`get_parent_properties`, `WebshopCategory`.`margin`, `WebshopCategory`.`limit_date_from`, `WebshopCategory`.`limit_date_to`, `WebshopCategory`.`imagesizes`, `WebshopCategory`.`active`, `WebshopCategory`.`ordered`, `WebshopCategory`.`oldid`, `WebshopCategory`.`oldid_hash`, `WebshopCategory`.`deleted`, `WebshopCategory`.`deleted_date`, `WebshopCategory`.`created`, `WebshopCategory`.`modified` FROM `hyundai60_hu`.`studio_webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = 25 LIMIT 1110
10SELECT `WebshopProduct`.*, `WebshopCategory`.*, `WebshopPrice`.*, `WebshopStock`.*, `WebshopMainImage`.*, `WebshopCategoryI18nName`.*, `WebshopCategoryI18nSeourl`.*, `WebshopBackImage`.*, `WebshopMainImage`.`picture`, `WebshopMainImage`.`width`, `WebshopMainImage`.`height`, `WebshopMainImage`.`main`, `WebshopMainImage`.`id`, `WebshopMainImage`.`deleted`, `WebshopBackImage`.`picture`, `WebshopBackImage`.`width`, `WebshopBackImage`.`height`, `WebshopBackImage`.`main`, `WebshopBackImage`.`id`, `WebshopBackImage`.`deleted`, `WebshopCategory`.`id`, `WebshopCategory`.`name`, `WebshopCategory`.`parent_id`, `WebshopCategory`.`seourl`, `WebshopCategory`.`picture`, `WebshopCategory`.`webshop_product_count`, `WebshopCategory`.`lft`, `WebshopCategory`.`rght`, `WebshopCategory`.`ordered`, `WebshopProduct`.`id`, (`I18n__name`.`content`) AS `WebshopProduct__i18n_name`, (`I18n__seourl`.`content`) AS `WebshopProduct__i18n_seourl`, (`I18n__description`.`content`) AS `WebshopProduct__i18n_description` FROM `hyundai60_hu`.`studio_webshop_products` AS `WebshopProduct` LEFT JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `WebshopCategoryI18nName` ON (`WebshopProduct`.`webshop_category_id` = `WebshopCategoryI18nName`.`foreign_key` and `WebshopCategoryI18nName`.`field`="name" and `WebshopCategoryI18nName`.`locale`="hun") LEFT JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `WebshopCategoryI18nSeourl` ON (`WebshopProduct`.`webshop_category_id` = `WebshopCategoryI18nSeourl`.`foreign_key` and `WebshopCategoryI18nSeourl`.`field`="seourl" and `WebshopCategoryI18nSeourl`.`locale`="hun") INNER JOIN `hyundai60_hu`.`studio_webshop_product_i18ns` AS `I18n__name` ON (`WebshopProduct`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'WebshopProduct' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_webshop_product_i18ns` AS `I18n__seourl` ON (`WebshopProduct`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'WebshopProduct' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_webshop_product_i18ns` AS `I18n__description` ON (`WebshopProduct`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'WebshopProduct' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_webshop_categories` AS `WebshopCategory` ON (`WebshopProduct`.`webshop_category_id` = `WebshopCategory`.`id`) LEFT JOIN `hyundai60_hu`.`studio_webshop_images` AS `WebshopMainImage` ON (`WebshopMainImage`.`webshop_product_id` = `WebshopProduct`.`id` AND `WebshopMainImage`.`main` = 1 AND `WebshopMainImage`.`deleted` = 0) LEFT JOIN `hyundai60_hu`.`studio_webshop_images` AS `WebshopBackImage` ON (`WebshopBackImage`.`webshop_product_id` = `WebshopProduct`.`id` AND `WebshopBackImage`.`back` = 1 AND `WebshopBackImage`.`deleted` = 0) LEFT JOIN `hyundai60_hu`.`studio_webshop_prices` AS `WebshopPrice` ON (`WebshopPrice`.`webshop_product_id` = `WebshopProduct`.`id` AND `WebshopPrice`.`main` = 1 AND `WebshopPrice`.`deleted` = 0) LEFT JOIN `hyundai60_hu`.`studio_webshop_stocks` AS `WebshopStock` ON (`WebshopStock`.`webshop_product_id` = `WebshopProduct`.`id` AND `WebshopStock`.`deleted` = 0) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `WebshopProduct`.`id` AND `Seo`.`related_model_name` = 'WebshopProduct' AND `Seo`.`locale` = 'hun') WHERE ((`WebshopCategory`.`id` = 25) AND (((((`same_main` = 0) AND (`same_id` IS NULL))) OR (`same_main` = 1))) AND (((((`WebshopProduct`.`limit_date_from` <= '2018-05-23 06:47') AND (`WebshopProduct`.`limit_date_to` >= '2018-05-23 06:47'))) OR (`WebshopProduct`.`limit_date_from` IS NULL)))) AND `WebshopProduct`.`active` = 1 AND `WebshopProduct`.`deleted` != 1 ORDER BY `WebshopProduct`.`ordered` asc, `WebshopProduct`.`created` desc LIMIT 50002
11SELECT `WebshopCategory`.`id`, `WebshopCategory`.`name`, `WebshopCategory`.`description`, `WebshopCategory`.`seourl`, `WebshopCategory`.`picture`, `WebshopCategory`.`parent_id`, `WebshopCategory`.`lft`, `WebshopCategory`.`rght`, `WebshopCategory`.`cached_in_element`, `WebshopCategory`.`webshop_product_count`, `WebshopCategory`.`get_parent_properties`, `WebshopCategory`.`margin`, `WebshopCategory`.`limit_date_from`, `WebshopCategory`.`limit_date_to`, `WebshopCategory`.`imagesizes`, `WebshopCategory`.`active`, `WebshopCategory`.`ordered`, `WebshopCategory`.`oldid`, `WebshopCategory`.`oldid_hash`, `WebshopCategory`.`deleted`, `WebshopCategory`.`deleted_date`, `WebshopCategory`.`created`, `WebshopCategory`.`modified` FROM `hyundai60_hu`.`studio_webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = 25 LIMIT 1110
12SELECT `WebshopCategory`.`id`, `WebshopCategory`.`lft`, `WebshopCategory`.`rght`, (`I18n__name`.`content`) AS `WebshopCategory__i18n_name`, (`I18n__seourl`.`content`) AS `WebshopCategory__i18n_seourl` FROM `hyundai60_hu`.`studio_webshop_categories` AS `WebshopCategory` INNER JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `I18n__name` ON (`WebshopCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'WebshopCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `I18n__seourl` ON (`WebshopCategory`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'WebshopCategory' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') WHERE lft <=1 AND rght >=2 ORDER BY `lft` asc110
13SELECT `WebshopCategory`.`id`, `WebshopCategory`.`name`, `WebshopCategory`.`description`, `WebshopCategory`.`seourl`, `WebshopCategory`.`picture`, `WebshopCategory`.`parent_id`, `WebshopCategory`.`lft`, `WebshopCategory`.`rght`, `WebshopCategory`.`cached_in_element`, `WebshopCategory`.`webshop_product_count`, `WebshopCategory`.`get_parent_properties`, `WebshopCategory`.`margin`, `WebshopCategory`.`limit_date_from`, `WebshopCategory`.`limit_date_to`, `WebshopCategory`.`imagesizes`, `WebshopCategory`.`active`, `WebshopCategory`.`ordered`, `WebshopCategory`.`oldid`, `WebshopCategory`.`oldid_hash`, `WebshopCategory`.`deleted`, `WebshopCategory`.`deleted_date`, `WebshopCategory`.`created`, `WebshopCategory`.`modified`, (`I18n__name`.`content`) AS `WebshopCategory__i18n_name`, (`I18n__seourl`.`content`) AS `WebshopCategory__i18n_seourl`, `Seo`.`id`, `Seo`.`related_model_id`, `Seo`.`related_model_name`, `Seo`.`title`, `Seo`.`description`, `Seo`.`keywords`, `Seo`.`slug`, `Seo`.`locale`, `Seo`.`created`, `Seo`.`modified` FROM `hyundai60_hu`.`studio_webshop_categories` AS `WebshopCategory` INNER JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `I18n__name` ON (`WebshopCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'WebshopCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_webshop_category_i18ns` AS `I18n__seourl` ON (`WebshopCategory`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'WebshopCategory' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `WebshopCategory`.`id` AND `Seo`.`related_model_name` = 'WebshopCategory' AND `Seo`.`locale` = 'hun') WHERE `WebshopCategory`.`id` = 25 LIMIT 1111
14SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
15SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`activatemenu`, `Page`.`pageorder`, `Page`.`parent_id`, `ParentSeourl`.`content` AS `parent_seourl`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__seourl`.`content`) AS `Page__i18n_seourl`, `Page`.`id` FROM `hyundai60_hu`.`studio_pages` AS `Page` LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentTitle` ON (`ParentTitle`.`foreign_key` = `Page`.`parent_id` AND `ParentTitle`.`locale` = 'hun' AND `ParentTitle`.`field` = 'title') LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentSeourl` ON (`ParentSeourl`.`foreign_key` = `Page`.`parent_id` AND `ParentSeourl`.`locale` = 'hun' AND `ParentSeourl`.`field` = 'seourl') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__seourl` ON (`Page`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'Page' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`Page`.`slider_id` = `Slider`.`id`) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Page`.`id` AND `Seo`.`related_model_name` = 'Page' AND `Seo`.`locale` = 'hun') WHERE `Page`.`deleted` != 1 AND `Page`.`notinmenu` = 0 AND `Page`.`active` = 1 ORDER BY `lft` ASC18180
16SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
17SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`activatemenu`, `Page`.`pageorder`, `Page`.`parent_id`, `ParentSeourl`.`content` AS `parent_seourl`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__seourl`.`content`) AS `Page__i18n_seourl`, `Page`.`id` FROM `hyundai60_hu`.`studio_pages` AS `Page` LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentTitle` ON (`ParentTitle`.`foreign_key` = `Page`.`parent_id` AND `ParentTitle`.`locale` = 'hun' AND `ParentTitle`.`field` = 'title') LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentSeourl` ON (`ParentSeourl`.`foreign_key` = `Page`.`parent_id` AND `ParentSeourl`.`locale` = 'hun' AND `ParentSeourl`.`field` = 'seourl') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__seourl` ON (`Page`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'Page' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`Page`.`slider_id` = `Slider`.`id`) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Page`.`id` AND `Seo`.`related_model_name` = 'Page' AND `Seo`.`locale` = 'hun') WHERE `Page`.`deleted` != 1 AND `Page`.`notinmenu` = 0 AND `Page`.`active` = 1 ORDER BY `lft` ASC18180