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