| 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
|
OFFICIAL TIMEKEEPER 
Photos
