0.0007 |
SHOW TABLES FROM `fuorisal_fs19`
|
0.0003 |
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` = 'page_debug' AND `env` = 'production'
|
0.0711 |
SELECT fs_focus_articles.* FROM `fs_focus_articles` WHERE ( fs_focus_articles.published_by_language = "[all]" OR fs_focus_articles.published_by_language LIKE "%[2]%" ) AND `main_sponsor` = 1 AND `publication_date` < '2021-01-18 08:17:54' 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 "%[2]%" ) AND `article_id` = 169 AND `publication_date` < '2021-01-18 08:17:54' ORDER BY RAND() LIMIT 1
|
0.0025 |
SELECT fs_focus_articles.* FROM `fs_focus_articles` WHERE ( fs_focus_articles.published_by_language = "[all]" OR fs_focus_articles.published_by_language LIKE "%[2]%" ) AND `main_sponsor` = 0 AND `article_id` NOT IN(169) AND `publication_date` < '2021-01-18 08:17:54' ORDER BY RAND() LIMIT 5
|
0.0680 |
SELECT fs_discover_articles.* FROM `fs_discover_articles` WHERE ( fs_discover_articles.published_by_language = "[all]" OR fs_discover_articles.published_by_language LIKE "%[2]%" ) AND `article_id` = 345 AND `publication_date` < '2021-01-18 08:17:54' ORDER BY `publication_date` desc LIMIT 1
|
0.1009 |
SELECT fs_discover_articles.* FROM `fs_discover_articles` WHERE ( fs_discover_articles.published_by_language = "[all]" OR fs_discover_articles.published_by_language LIKE "%[2]%" ) AND `article_id` NOT IN(345) AND `publication_date` < '2021-01-18 08:17:54' ORDER BY RAND() LIMIT 11
|
0.0012 |
SELECT fs_stories_articles.* FROM `fs_stories_articles` WHERE ( fs_stories_articles.published_by_language = "[all]" OR fs_stories_articles.published_by_language LIKE "%[2]%" ) AND `publication_date` < '2021-01-18 08:17:55' ORDER BY RAND() LIMIT 2
|
0.2120 |
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` = 2 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.0779 |
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` = 2 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.0022 |
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.0432 |
SELECT DISTINCT fs_ereporters_images.id FROM `fs_ereporters_images` JOIN `fs_ereporters_images_i18n` ON `fs_ereporters_images_i18n`.`foreign_id` = `fs_ereporters_images`.`id` LEFT JOIN `scms_users` ON `fs_ereporters_images`.`created_by` = `scms_users`.`id` WHERE `fs_ereporters_images`.`foreign_id` IN('3423', '3290') AND `fs_ereporters_images`.`group` IN('profilo')
|
0.0035 |
SELECT fs_ereporters_images.*, fs_ereporters_images_i18n.title, fs_ereporters_images_i18n.description, fs_ereporters_images_i18n.link, fs_ereporters_images_i18n.language_id, `scms_users`.`username` as `author` FROM `fs_ereporters_images` JOIN `fs_ereporters_images_i18n` ON `fs_ereporters_images_i18n`.`foreign_id` = `fs_ereporters_images`.`id` LEFT JOIN `scms_users` ON `fs_ereporters_images`.`created_by` = `scms_users`.`id` WHERE `fs_ereporters_images`.`id` IN('5', '47') AND `fs_ereporters_images`.`foreign_id` IN('3423', '3290') AND `fs_ereporters_images`.`group` IN('profilo') ORDER BY `fs_ereporters_images`.`foreign_id` ASC, `fs_ereporters_images`.`group` ASC, `fs_ereporters_images`.`position` ASC
|
0.1058 |
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` = 2 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.0009 |
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.0007 |
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.0009 |
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.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.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('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.0338 |
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
|