0.0007 |
SHOW TABLES FROM `fuorisal_fs19`
|
0.0008 |
SELECT * FROM `scms_languages` ORDER BY `default` DESC
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `default` = 1
|
0.0003 |
SELECT * FROM `scms_modules` WHERE `slug` = 'home_page_fs'
|
0.0002 |
SELECT `slug`, `value` FROM `scms_theme_options` WHERE `theme` = 'fuorisalone'
|
0.0005 |
SELECT *, IF(`value` = "", `default`, `value`) as `value` FROM `scms_settings` WHERE `module` = 'production' AND `env` = 'production' ORDER BY `group` ASC, `order` DESC
|
0.0003 |
SELECT *, IF(`value` = "", `default`, `value`) as `value` FROM `scms_settings` WHERE `slug` = 'ga_tracking' AND `env` = 'production'
|
0.0002 |
SELECT *, IF(`value` = "", `default`, `value`) as `value` FROM `scms_settings` WHERE `slug` = 'page_debug' AND `env` = 'production'
|
0.0012 |
SELECT DISTINCT(fs_itineraries.id), menu_pos, fs_itineraries_i18n.titolo FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`status` = 1 ORDER BY `menu_pos` ASC
|
0.0024 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` IN('1', '2', '3', '38', '38', '7', '7', '37', '9', '37', '39', '39', '6', '31', '31', '28', '28', '32', '29', '29', '16', '20', '20', '33', '33', '35', '35', '36', '36', '34', '18', '18', '30', '24', '19') ORDER BY `menu_pos` ASC
|
0.0010 |
SELECT DISTINCT fs_itineraries_images.id FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`foreign_id` IN('1', '2', '3', '7', '38', '9', '37', '6', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30', '24', '19') AND `fs_itineraries_images`.`group` IN('logo', 'gallery', 'banner')
|
0.0025 |
SELECT fs_itineraries_images.*, fs_itineraries_images_i18n.title, fs_itineraries_images_i18n.description, fs_itineraries_images_i18n.link, fs_itineraries_images_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`id` IN('26', '150', '155', '158', '240', '283', '287', '288', '289', '290', '291', '292', '293', '296', '297', '298', '299', '300', '301', '302', '303', '304', '305', '306', '307', '319', '322', '334', '335', '336', '337', '338', '339', '340', '341', '342', '345', '346', '347', '348', '349', '351', '386', '387', '388', '389', '426', '427', '428', '437', '440', '441', '488', '495', '497', '501', '502', '524', '525', '526', '527', '528', '529', '552', '557', '558', '559', '560', '561', '562', '571', '572', '573', '574', '575', '578', '579', '580', '581', '582', '584', '585', '587', '590', '591', '592', '593', '594', '595', '596', '597', '598', '599', '600') AND `fs_itineraries_images`.`foreign_id` IN('1', '2', '3', '7', '38', '9', '37', '6', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30', '24', '19') AND `fs_itineraries_images`.`group` IN('logo', 'gallery', 'banner') ORDER BY `fs_itineraries_images`.`foreign_id` ASC, `fs_itineraries_images`.`group` ASC, `fs_itineraries_images`.`position` ASC
|
0.0005 |
SELECT DISTINCT fs_itineraries_files.id FROM `fs_itineraries_files` JOIN `fs_itineraries_files_i18n` ON `fs_itineraries_files_i18n`.`foreign_id` = `fs_itineraries_files`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_files`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_files`.`foreign_id` IN('1', '2', '3', '7', '38', '9', '37', '6', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30', '24', '19') AND `fs_itineraries_files`.`group` IN('press_release')
|
0.0007 |
SELECT fs_itineraries_files.*, fs_itineraries_files_i18n.title, fs_itineraries_files_i18n.description, fs_itineraries_files_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_itineraries_files` JOIN `fs_itineraries_files_i18n` ON `fs_itineraries_files_i18n`.`foreign_id` = `fs_itineraries_files`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_files`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_files`.`id` IN('24', '40', '41', '43', '44', '53', '55') AND `fs_itineraries_files`.`foreign_id` IN('1', '2', '3', '7', '38', '9', '37', '6', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30', '24', '19') AND `fs_itineraries_files`.`group` IN('press_release') ORDER BY `fs_itineraries_files`.`foreign_id` ASC, `fs_itineraries_files`.`group` ASC, `fs_itineraries_files`.`position` ASC
|
0.0012 |
SELECT fs_focus_articles.* FROM `fs_focus_articles` WHERE ( fs_focus_articles.published_by_language = "[all]" OR fs_focus_articles.published_by_language LIKE "%[1]%" ) AND `main_sponsor` = 1 AND `publication_date` < '2021-03-09 11:26:43' ORDER BY RAND() LIMIT 2
|
0.0008 |
SELECT fs_focus_articles.* FROM `fs_focus_articles` WHERE ( fs_focus_articles.published_by_language = "[all]" OR fs_focus_articles.published_by_language LIKE "%[1]%" ) AND `article_id` = 169 AND `publication_date` < '2021-03-09 11:26:43' ORDER BY RAND() LIMIT 1
|
0.0028 |
SELECT fs_focus_articles.* FROM `fs_focus_articles` WHERE ( fs_focus_articles.published_by_language = "[all]" OR fs_focus_articles.published_by_language LIKE "%[1]%" ) AND `main_sponsor` = 0 AND `article_id` NOT IN(169) AND `publication_date` < '2021-03-09 11:26:43' ORDER BY RAND() LIMIT 5
|
0.0004 |
SELECT fs_discover_articles.* FROM `fs_discover_articles` WHERE ( fs_discover_articles.published_by_language = "[all]" OR fs_discover_articles.published_by_language LIKE "%[1]%" ) AND `article_id` = 345 AND `publication_date` < '2021-03-09 11:26:43' ORDER BY `publication_date` desc LIMIT 1
|
0.0031 |
SELECT fs_discover_articles.* FROM `fs_discover_articles` WHERE ( fs_discover_articles.published_by_language = "[all]" OR fs_discover_articles.published_by_language LIKE "%[1]%" ) AND `article_id` NOT IN(345) AND `publication_date` < '2021-03-09 11:26:43' ORDER BY RAND() LIMIT 11
|
0.0008 |
SELECT fs_stories_articles.* FROM `fs_stories_articles` WHERE ( fs_stories_articles.published_by_language = "[all]" OR fs_stories_articles.published_by_language LIKE "%[1]%" ) AND `publication_date` < '2021-03-09 11:26:43' ORDER BY RAND() LIMIT 2
|
0.2170 |
SELECT fs_ereporters_images.*, fs_photos.*, fs_ereporters_images.id as ereporter_image_id, CONCAT(fs_ereporters.nome, " ", fs_ereporters.cognome) as author, `fs_events_i18n`.`titolo` as `titolo_evento` FROM `fs_photos` LEFT JOIN `fs_ereporters` ON `fs_photos`.`created_by` = `fs_ereporters`.`user_id` LEFT JOIN `fs_ereporters_images` ON `fs_photos`.`created_by` = `fs_ereporters_images`.`foreign_id` AND `GROUP` = "profilo" LEFT JOIN `fs_events` ON `fs_photos`.`event_id` = `fs_events`.`id` LEFT JOIN `fs_events_i18n` ON `fs_events`.`id` = `fs_events_i18n`.`foreign_id` AND `fs_events_i18n`.`language_id` = 1 LEFT JOIN `fs_itineraries_events` ON `fs_photos`.`event_id` = `fs_itineraries_events`.`event_id` WHERE `fs_photos`.`status` = 1 GROUP BY `fs_photos`.`id`, `ereporter_image_id`, `author` ORDER BY RAND() LIMIT 14
|
0.0788 |
SELECT `fs_photos`.`id`, CONCAT(fs_ereporters.nome, fs_ereporters.cognome) as author, `fs_events_i18n`.`titolo` as `titolo_evento` FROM `fs_photos` LEFT JOIN `fs_ereporters` ON `fs_photos`.`created_by` = `fs_ereporters`.`user_id` LEFT JOIN `fs_events` ON `fs_photos`.`event_id` = `fs_events`.`id` LEFT JOIN `fs_events_i18n` ON `fs_events`.`id` = `fs_events_i18n`.`foreign_id` AND `fs_events_i18n`.`language_id` = 1 LEFT JOIN `fs_itineraries_events` ON `fs_photos`.`event_id` = `fs_itineraries_events`.`event_id` WHERE `fs_photos`.`status` = 1 GROUP BY `fs_photos`.`id`, `author`
|
0.0018 |
SELECT fs_ereporters.*, scms_users.*, scms_countries.country_name FROM `fs_ereporters` LEFT JOIN `scms_users` ON `fs_ereporters`.`user_id` = `scms_users`.`id` LEFT JOIN `scms_countries` ON `fs_ereporters`.`country_code` = `scms_countries`.`country_code` WHERE `active` = 1 ORDER BY RAND() LIMIT 2
|
0.1075 |
SELECT DISTINCT(fs_events.id) FROM `fs_events` JOIN `fs_events_i18n` ON `fs_events_i18n`.`foreign_id` = `fs_events`.`id` AND `fs_events_i18n`.`language_id` = 1 LEFT JOIN `scms_users` ON `fs_events`.`created_by` = `scms_users`.`id` LEFT JOIN `fs_locations` ON `fs_events`.`location_id` = `fs_locations`.`id` LEFT JOIN `fs_itineraries_events` ON `fs_events`.`id` = `fs_itineraries_events`.`event_id` LEFT JOIN `fs_events_brands` ON `fs_events`.`id` = `fs_events_brands`.`event_id` LEFT JOIN `fs_brands` ON `fs_events_brands`.`item_id` = `fs_brands`.`id` LEFT JOIN `fs_events_designers` ON `fs_events`.`id` = `fs_events_designers`.`event_id` LEFT JOIN `fs_designers` ON `fs_events_designers`.`item_id` = `fs_designers`.`id` LEFT JOIN `fs_events_categories` ON `fs_events`.`id` = `fs_events_categories`.`event_id` WHERE `fs_events`.`status` = 1 GROUP BY `fs_events`.`id`, `fs_itineraries_events`.`itinerary_id`, `fs_itineraries_events`.`event_id`, `fs_events_brands`.`item_id`, `fs_events_designers`.`item_id`, `fs_events_categories`.`item_id`
|
0.0007 |
SELECT COUNT(*) AS `numrows` FROM ( SELECT DISTINCT(fs_itineraries.id) FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_i18n`.`language_id` = '1' AND `fs_itineraries`.`status` = 1 GROUP BY `fs_itineraries`.`id` ) CI_count_all_results
|
0.0006 |
SELECT DISTINCT(fs_itineraries.id), menu_pos, fs_itineraries_i18n.titolo FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`status` = 1 AND `fs_itineraries`.`tipo_itinerario` = 'zona_design' ORDER BY `menu_pos` ASC
|
0.0013 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` IN('1', '2', '3', '7', '7', '9', '6', '24', '19') ORDER BY `menu_pos` ASC
|
0.0006 |
SELECT DISTINCT fs_itineraries_images.id FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`foreign_id` IN('1', '2', '3', '7', '9', '6', '24', '19') AND `fs_itineraries_images`.`group` IN('logo', 'cover_thumb')
|
0.0007 |
SELECT fs_itineraries_images.*, fs_itineraries_images_i18n.title, fs_itineraries_images_i18n.description, fs_itineraries_images_i18n.link, fs_itineraries_images_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`id` IN('26', '150', '158', '240', '283', '286', '309', '311', '322', '333', '425', '437', '439', '489', '491', '502') AND `fs_itineraries_images`.`foreign_id` IN('1', '2', '3', '7', '9', '6', '24', '19') AND `fs_itineraries_images`.`group` IN('logo', 'cover_thumb') ORDER BY `fs_itineraries_images`.`foreign_id` ASC, `fs_itineraries_images`.`group` ASC, `fs_itineraries_images`.`position` ASC
|
0.0006 |
SELECT DISTINCT(fs_itineraries.id), menu_pos, fs_itineraries_i18n.titolo FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`status` = 2 AND `fs_itineraries`.`id` IN(5, 10, 23, 25, 26, 27) AND `fs_itineraries`.`tipo_itinerario` = 'zona_design' ORDER BY `menu_pos` ASC
|
0.0010 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` IN('5', '23', '25', '26', '27', '10') ORDER BY `menu_pos` ASC
|
0.0007 |
SELECT DISTINCT(fs_itineraries.id), menu_pos, fs_itineraries_i18n.titolo FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` NOT IN(9999, 9998) AND `fs_itineraries`.`status` = 1 AND `fs_itineraries`.`tipo_itinerario` = 'percorso_tematico' ORDER BY `menu_pos` ASC
|
0.0014 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` IN('38', '38', '37', '37', '39', '39', '31', '31', '28', '28', '32', '29', '29', '16', '20', '20', '33', '33', '35', '35', '36', '36', '34', '18', '18', '30') ORDER BY `menu_pos` ASC
|
0.0006 |
SELECT DISTINCT fs_itineraries_images.id FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`foreign_id` IN('38', '37', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30') AND `fs_itineraries_images`.`group` IN('logo', 'cover_thumb')
|
0.0008 |
SELECT fs_itineraries_images.*, fs_itineraries_images_i18n.title, fs_itineraries_images_i18n.description, fs_itineraries_images_i18n.link, fs_itineraries_images_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`id` IN('293', '295', '315', '386', '390', '392', '487', '495', '496', '552', '564', '567', '568', '569', '576', '583', '588', '589', '601') AND `fs_itineraries_images`.`foreign_id` IN('38', '37', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30') AND `fs_itineraries_images`.`group` IN('logo', 'cover_thumb') ORDER BY `fs_itineraries_images`.`foreign_id` ASC, `fs_itineraries_images`.`group` ASC, `fs_itineraries_images`.`position` ASC
|
0.0007 |
SELECT DISTINCT(fs_itineraries.id), menu_pos, fs_itineraries_i18n.titolo FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`status` = 1 AND `fs_itineraries`.`tipo_itinerario` = 'percorso_tematico' ORDER BY `menu_pos` ASC
|
0.0016 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`id` IN('38', '38', '37', '37', '39', '39', '31', '31', '28', '28', '32', '29', '29', '16', '20', '20', '33', '33', '35', '35', '36', '36', '34', '18', '18', '30') ORDER BY `menu_pos` ASC
|
0.0005 |
SELECT DISTINCT fs_itineraries_images.id FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`foreign_id` IN('38', '37', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30') AND `fs_itineraries_images`.`group` IN('cover_thumb')
|
0.0008 |
SELECT fs_itineraries_images.*, fs_itineraries_images_i18n.title, fs_itineraries_images_i18n.description, fs_itineraries_images_i18n.link, fs_itineraries_images_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_itineraries_images` JOIN `fs_itineraries_images_i18n` ON `fs_itineraries_images_i18n`.`foreign_id` = `fs_itineraries_images`.`id` LEFT JOIN `scms_users` ON `fs_itineraries_images`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries_images`.`id` IN('295', '315', '390', '392', '487', '496', '564', '567', '568', '569', '576', '583', '588', '589', '601') AND `fs_itineraries_images`.`foreign_id` IN('38', '37', '31', '39', '28', '32', '29', '16', '20', '33', '35', '36', '34', '18', '30') AND `fs_itineraries_images`.`group` IN('cover_thumb') ORDER BY `fs_itineraries_images`.`foreign_id` ASC, `fs_itineraries_images`.`group` ASC, `fs_itineraries_images`.`position` ASC
|
0.0024 |
SELECT fs_itineraries.*, fs_itineraries_i18n.titolo, fs_itineraries_i18n.slug, fs_itineraries_i18n.claim, fs_itineraries_i18n.sponsor_i18n, fs_itineraries_i18n.descrizione, fs_itineraries_i18n.sidebar, fs_itineraries_i18n.meta_keywords, fs_itineraries_i18n.meta_title, fs_itineraries_i18n.meta_description, fs_itineraries_i18n.language_id, (SELECT COUNT(*) FROM fs_itineraries_events WHERE fs_itineraries_events.itinerary_id = fs_itineraries.id) as num_events, `scms_users`.`username` as `author` FROM `fs_itineraries` JOIN `fs_itineraries_i18n` ON `fs_itineraries_i18n`.`foreign_id` = `fs_itineraries`.`id` LEFT JOIN `scms_users` ON `fs_itineraries`.`created_by` = `scms_users`.`id` WHERE `fs_itineraries`.`status` = 1 AND `fs_itineraries`.`tipo_itinerario` = 'zona_design' ORDER BY `fs_itineraries_i18n`.`titolo` ASC
|
0.0353 |
SELECT fs_locations.*, scms_users.username as author FROM `fs_locations` LEFT JOIN `scms_users` ON `fs_locations`.`created_by` = `scms_users`.`id` WHERE `fs_locations`.`status` = 1 ORDER BY `fs_locations`.`nome` ASC
|
0.0012 |
SELECT DISTINCT(fs_categories.id), fs_categories_i18n.nome as nome_categoria, fs_macrocategories_i18n.nome as nome_macrocategoria FROM `fs_categories` JOIN `fs_categories_i18n` ON `fs_categories_i18n`.`foreign_id` = `fs_categories`.`id` LEFT JOIN `fs_macrocategories` ON `fs_categories`.`macrocategory_id` = `fs_macrocategories`.`id` LEFT JOIN `fs_macrocategories_i18n` ON `fs_macrocategories_i18n`.`foreign_id` = `fs_macrocategories`.`id` LEFT JOIN `scms_users` ON `fs_categories`.`created_by` = `scms_users`.`id` WHERE `fs_categories`.`status` = 1 AND `fs_macrocategories`.`status` = 1 GROUP BY `fs_categories`.`id` ORDER BY `fs_macrocategories_i18n`.`nome` ASC, `fs_categories_i18n`.`nome` ASC
|
0.0013 |
SELECT fs_categories.*, fs_categories_i18n.nome, fs_categories_i18n.slug, fs_categories_i18n.meta_keywords, fs_categories_i18n.meta_title, fs_categories_i18n.meta_description, fs_categories_i18n.language_id, fs_macrocategories_i18n.nome as nome_macrocategoria, `scms_users`.`username` as `author` FROM `fs_categories` JOIN `fs_categories_i18n` ON `fs_categories_i18n`.`foreign_id` = `fs_categories`.`id` LEFT JOIN `fs_macrocategories` ON `fs_categories`.`macrocategory_id` = `fs_macrocategories`.`id` LEFT JOIN `fs_macrocategories_i18n` ON `fs_macrocategories_i18n`.`foreign_id` = `fs_macrocategories`.`id` LEFT JOIN `scms_users` ON `fs_categories`.`created_by` = `scms_users`.`id` WHERE `fs_categories`.`id` IN('7', '6', '8', '13', '17', '11', '14', '18', '16', '3', '4', '9', '15', '2', '19', '1', '12', '10') ORDER BY `fs_macrocategories_i18n`.`nome` ASC, `fs_categories_i18n`.`nome` ASC
|
0.0003 |
SELECT *, IF(`value` = "", `default`, `value`) as `value` FROM `scms_settings` WHERE `slug` = 'site_name' AND `env` = 'production'
|
0.0003 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0004 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|
0.0002 |
SELECT * FROM `scms_languages` WHERE `active` = 1
|