| 0.0005 |
SET SESSION sql_mode="STRICT_ALL_TABLES"
|
| 0.0013 |
SHOW TABLES FROM `viviquii0225`
|
| 0.0004 |
SELECT *
FROM (`default_migrations`)
|
| 0.0037 |
INSERT INTO `default_ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('4700866b4ee340feb339e9071a685bba', '3.84.243.246', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1550490456, '')
|
| 0.0009 |
SELECT *, IF(`value` = "", `default`, `value`) as `value`
FROM (`default_settings`)
ORDER BY `order` DESC
|
| 0.0011 |
SELECT *
FROM (`default_modules`)
WHERE `enabled` = 1
|
| 0.0011 |
SELECT `default_users`.*, `default_groups`.`name` AS `group`, `default_groups`.`description` AS `group_description`, IF(default_profiles.last_name = "",default_profiles.first_name, CONCAT(default_profiles.first_name," ",default_profiles.last_name)) AS full_name, `default_profiles`.`display_name`, `default_profiles`.`first_name`, `default_profiles`.`last_name`, `default_profiles`.`company`, `default_profiles`.`lang`, `default_profiles`.`bio`, `default_profiles`.`dob`, `default_profiles`.`gender`, `default_profiles`.`phone`, `default_profiles`.`mobile`, `default_profiles`.`address_line1`, `default_profiles`.`address_line2`, `default_profiles`.`address_line3`, `default_profiles`.`postcode`, `default_profiles`.`website`, `default_profiles`.`updated_on`
FROM (`default_users`)
LEFT JOIN `default_profiles` ON `default_users`.`id` = `default_profiles`.`user_id`
LEFT JOIN `default_groups` ON `default_users`.`group_id` = `default_groups`.`id`
WHERE `default_users`.`email` IS NULL
LIMIT 1
|
| 0.0006 |
SELECT *
FROM (`default_modules`)
WHERE `slug` = 'periscopio'
|
| 0.0005 |
SELECT *
FROM (`default_redirects`)
WHERE `from` = 'periscopio/preferiti'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM (`default_modules`)
WHERE `slug` = 'blog'
|
| 0.0004 |
SELECT *
FROM (`default_variables`)
|
| 0.0003 |
SELECT `slug`, `value`
FROM (`default_theme_options`)
WHERE `theme` = 'viviqui'
|
| 0.0004 |
SELECT *
FROM (`default_file_folders`)
WHERE `slug` = 'annunci-periscopio'
|
| 0.0008 |
SELECT *
FROM (`default_vq_site`)
WHERE `slug` = 'periscopio'
|
| 0.0019 |
SELECT *
FROM (`default_per_advertising_special`)
JOIN `default_per_advertising` ON `default_per_advertising`.`id`=`default_per_advertising_special`.`per_advertising_id`
WHERE `special_offer_active` = 1
AND `special_data_start` <= '2019-02-18 11:47:36'
AND `special_data_stop` >= '2019-02-18 11:47:36'
AND `special_offers_code` = 'PP8'
AND `default_per_advertising`.`adv_validate` = 1
AND `default_per_advertising`.`validate` = 1
|
| 0.0010 |
SELECT *
FROM (`default_per_category`)
GROUP BY `folder`
|
| 0.0005 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'accessori casa'
|
| 0.0004 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'arte e preziosi'
|
| 0.0005 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'attrezzature'
|
| 0.0004 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'editoria'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'elettronica'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'immobili'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'lavoro'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'mercatino'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'mercauto'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'messaggi'
|
| 0.0003 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'musica'
|
| 0.0004 |
SELECT *
FROM (`default_per_category`)
WHERE `folder` = 'tempo libero'
|
| 0.0003 |
SELECT *
FROM (`default_per_region`)
ORDER BY `name` asc
|
| 0.0019 |
SELECT *
FROM (`default_per_advertising_special`)
JOIN `default_per_advertising` ON `default_per_advertising`.`id`=`default_per_advertising_special`.`per_advertising_id`
WHERE `special_offer_active` = 1
AND `special_data_start` <= '2019-02-18 11:47:36'
AND `special_data_stop` >= '2019-02-18 11:47:36'
AND `special_offers_code` IN ('AE30', 'AE7')
AND `default_per_advertising`.`adv_validate` = 1
AND `default_per_advertising`.`validate` = 1
ORDER BY RAND()
LIMIT 3
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM (`default_modules`)
WHERE `slug` = 'showcases'
|
| 0.0005 |
SELECT *
FROM (`default_paq_display_colorscheme`)
|
| 0.0007 |
SELECT *
FROM (`default_paq_display`)
JOIN `default_vq_site_assoc` ON `default_paq_display`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_display')
AND `enabled` = 1
ORDER BY `roworder`
|
| 0.0003 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '3'
|
| 0.0009 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '12'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '5152'
|
| 0.0005 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '76'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '5350'
|
| 0.0003 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '4'
|
| 0.0006 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '16'
|
| 0.0007 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '5131'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '5130'
|
| 0.0041 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '11'
|
| 0.0008 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '13'
|
| 0.0008 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '1985'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '841'
|
| 0.0007 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '5348'
|
| 0.0003 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '8'
|
| 0.0007 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '10'
|
| 0.0007 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '4205'
|
| 0.0003 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '7'
|
| 0.0006 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '8'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '3614'
|
| 0.0003 |
SELECT *
FROM (`default_paq_display_colorscheme`)
WHERE `id` = '5'
|
| 0.0008 |
SELECT `default_vq_firm`.`id`, `default_vq_firm`.`name`
FROM (`default_vq_firm`)
JOIN `default_paq_showcase` ON `default_paq_showcase`.`firm_id` = `default_vq_firm`.`id`
JOIN `default_paq_display_firm` ON `default_paq_display_firm`.`firm_id` = `default_vq_firm`.`id`
WHERE `default_paq_showcase`.`ispublished` = 1
AND `default_vq_firm`.`ispublished` = 1
AND `default_paq_display_firm`.`display_id` = '9'
|
| 0.0006 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '2582'
|
| 0.0007 |
SELECT `default_paq_showcase`.*, `default_vq_firm`.`name` AS firm, `default_vq_firm`.`name` AS name
FROM (`default_paq_showcase`)
LEFT JOIN `default_vq_firm` ON `default_vq_firm`.`id` = `default_paq_showcase`.`firm_id`
WHERE `firm_id` = '2864'
|
| 0.0027 |
SELECT COUNT(*) AS `numrows`
FROM (`default_modules`)
WHERE `slug` = 'files'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '59455'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '55378'
|
| 0.0003 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '46256'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '41272'
|
| 0.0003 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '40485'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '4207'
|
| 0.0003 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '53171'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '61918'
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '241'
|
| 0.0003 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '15314'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM (`default_modules`)
WHERE `slug` = 'adv'
|
| 0.0007 |
SELECT *
FROM (`default_paq_advertising`)
JOIN `default_vq_site_assoc` ON `default_paq_advertising`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_advertising')
AND `ispublished` = 1
AND `position` = '1'
ORDER BY RAND()
LIMIT 1
|
| 0.0003 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '65450'
|
| 0.0009 |
SELECT *
FROM (`default_paq_advertising`)
JOIN `default_vq_site_assoc` ON `default_paq_advertising`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_advertising')
AND `ispublished` = 1
AND `position` = '2'
ORDER BY RAND()
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '61917'
|
| 0.0007 |
SELECT *
FROM (`default_paq_advertising`)
JOIN `default_vq_site_assoc` ON `default_paq_advertising`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_advertising')
AND `ispublished` = 1
AND `position` = '3'
ORDER BY RAND()
LIMIT 1
|
| 0.0005 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '55872'
|
| 0.0061 |
SELECT *
FROM (`default_paq_advertising`)
JOIN `default_vq_site_assoc` ON `default_paq_advertising`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_advertising')
AND `ispublished` = 1
AND `position` = '0'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM (`default_files`)
WHERE `type` = 'i'
AND `id` = '12997'
|
| 0.0005 |
SELECT *
FROM (`default_paq_advertising`)
JOIN `default_vq_site_assoc` ON `default_paq_advertising`.`id` = `default_vq_site_assoc`.`object_id`
WHERE (default_vq_site_assoc.`site_id` = 3
AND default_vq_site_assoc.`table_name` = 'paq_advertising')
AND `ispublished` = 1
AND `position` = '0'
LIMIT 1
|
