| | Siti Web Pronti

Categoria:

0 of 1

20 queries took 789 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `tms`	23	23	11
2	DESCRIBE `tm_categories`	7	7	17
3	DESCRIBE `tm_authors`	4	4	14
4	DESCRIBE `tm_styles`	2	2	19
5	DESCRIBE `tm_screenshots`	8	8	11
6	DESCRIBE `tm_assoc_categories`	3	3	12
7	DESCRIBE `tm_assoc_styles`	3	3	12
8	DESCRIBE `tm_types`	2	2	12
9	DESCRIBE `tm_views`	5	5	11
10	SELECT `TmCategory`.`id`, `TmCategory`.`it`, `TmCategory`.`slug_it`, `TmCategory`.`en`, `TmCategory`.`slug_en`, `TmCategory`.`created`, `TmCategory`.`modified` FROM `tm_categories` AS `TmCategory` WHERE `TmCategory`.`slug_it` = 'societ-agrave-e-cultura' LIMIT 1	0	0	1
11	SELECT `TmAssocCategory`.`tm_id`, `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` LEFT JOIN `tm_categories` AS `TmCategory` ON (`TmAssocCategory`.`tm_category_id` = `TmCategory`.`id`) WHERE `TmCategory`.`slug_it` = ('')	0	0	311
12	SELECT COUNT(*) AS `count` FROM `tms` AS `Tm` LEFT JOIN `tm_authors` AS `TmAuthor` ON (`Tm`.`author_id` = `TmAuthor`.`id`) LEFT JOIN `tm_types` AS `TmType` ON (`Tm`.`type_id` = `TmType`.`id`) WHERE `Tm`.`state` = 1 AND `Tm`.`id` IS NULL	1	1	1
13	SELECT `Tm`.`id`, `Tm`.`state`, `Tm`.`price`, `Tm`.`exc_price`, `Tm`.`inserted_date`, `Tm`.`update_date`, `Tm`.`downloads`, `Tm`.`type_id`, `Tm`.`is_flash`, `Tm`.`is_adult`, `Tm`.`width`, `Tm`.`author_id`, `Tm`.`is_full_site`, `Tm`.`is_real_size`, `Tm`.`keywords_en`, `Tm`.`keywords_it`, `Tm`.`description_it`, `Tm`.`description_en`, `Tm`.`software_required`, `Tm`.`sources`, `Tm`.`uri_demo`, `Tm`.`created`, `Tm`.`modified`, `TmAuthor`.`id`, `TmAuthor`.`nickname`, `TmAuthor`.`created`, `TmAuthor`.`modified`, `TmType`.`id`, `TmType`.`name` FROM `tms` AS `Tm` LEFT JOIN `tm_authors` AS `TmAuthor` ON (`Tm`.`author_id` = `TmAuthor`.`id`) LEFT JOIN `tm_types` AS `TmType` ON (`Tm`.`type_id` = `TmType`.`id`) WHERE `Tm`.`state` = 1 AND `Tm`.`id` IS NULL ORDER BY `Tm`.`id` desc LIMIT 15	0	0	1
14	SELECT DISTINCT `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` WHERE 1 = 1	107	107	34
15	SELECT `TmCategory`.`id`, `TmCategory`.`it`, `TmCategory`.`slug_it`, `TmCategory`.`en`, `TmCategory`.`slug_en`, `TmCategory`.`created`, `TmCategory`.`modified` FROM `tm_categories` AS `TmCategory` WHERE `TmCategory`.`it` != '' AND `id` IN (2, 56, 83, 63, 13, 3, 22, 10, 11, 14, 5, 19, 16, 7, 33, 34, 8, 23, 9, 78, 6, 25, 1, 18, 49, 42, 27, 50, 29, 21, 26, 24, 66, 35, 74, 76, 36, 47, 51, 40, 39, 4, 77, 75, 41, 43, 32, 44, 48, 65, 45, 70, 67, 46, 17, 60, 68, 53, 62, 64, 89, 54, 79, 55, 84, 81, 94, 98, 102, 93, 113, 97, 114, 80, 101, 71, 95, 72, 96, 91, 105, 92, 87, 88, 107, 109, 111, 69, 115, 61, 106, 103, 57, 100, 116, 86, 117, 112, 121, 119, 123, 122, 125, 118, 126, 138, 142) ORDER BY `TmCategory`.`it` ASC	104	104	2
16	SELECT DISTINCT `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` WHERE 1 = 1	107	107	0
17	SELECT `TmCategory`.`id`, `TmCategory`.`it`, `TmCategory`.`slug_it`, `TmCategory`.`en`, `TmCategory`.`slug_en`, `TmCategory`.`created`, `TmCategory`.`modified` FROM `tm_categories` AS `TmCategory` WHERE `TmCategory`.`it` != '' AND `id` IN (2, 56, 83, 63, 13, 3, 22, 10, 11, 14, 5, 19, 16, 7, 33, 34, 8, 23, 9, 78, 6, 25, 1, 18, 49, 42, 27, 50, 29, 21, 26, 24, 66, 35, 74, 76, 36, 47, 51, 40, 39, 4, 77, 75, 41, 43, 32, 44, 48, 65, 45, 70, 67, 46, 17, 60, 68, 53, 62, 64, 89, 54, 79, 55, 84, 81, 94, 98, 102, 93, 113, 97, 114, 80, 101, 71, 95, 72, 96, 91, 105, 92, 87, 88, 107, 109, 111, 69, 115, 61, 106, 103, 57, 100, 116, 86, 117, 112, 121, 119, 123, 122, 125, 118, 126, 138, 142) ORDER BY `TmCategory`.`it` ASC	104	104	1
18	SELECT DISTINCT `TmAuthor`.* FROM `tm_authors` AS `TmAuthor` LEFT JOIN `tms` AS `Tm` ON (`Tm`.`author_id` = `TmAuthor`.`id`) WHERE `Tm`.`id` IS NOT NULL ORDER BY `TmAuthor`.`nickname` ASC, `TmAuthor`.`id` ASC	135	135	278
19	SELECT count(id) AS num_Tm, `Tm`.`author_id` FROM `tms` AS `Tm` WHERE 1=1 GROUP BY author_id	140	140	40
20	SELECT `TmType`.`id`, `TmType`.`name` FROM `tm_types` AS `TmType` WHERE name != '' ORDER BY `name` ASC	22	22	1

20 queries took 789 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `tms`

DESCRIBE `tm_categories`

DESCRIBE `tm_authors`

DESCRIBE `tm_styles`

DESCRIBE `tm_screenshots`

DESCRIBE `tm_assoc_categories`

DESCRIBE `tm_assoc_styles`

DESCRIBE `tm_types`

DESCRIBE `tm_views`

SELECT `TmAssocCategory`.`tm_id`, `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` LEFT JOIN `tm_categories` AS `TmCategory` ON (`TmAssocCategory`.`tm_category_id` = `TmCategory`.`id`) WHERE `TmCategory`.`slug_it` = ('')

311

SELECT COUNT(*) AS `count` FROM `tms` AS `Tm` LEFT JOIN `tm_authors` AS `TmAuthor` ON (`Tm`.`author_id` = `TmAuthor`.`id`) LEFT JOIN `tm_types` AS `TmType` ON (`Tm`.`type_id` = `TmType`.`id`) WHERE `Tm`.`state` = 1 AND `Tm`.`id` IS NULL

SELECT `Tm`.`id`, `Tm`.`state`, `Tm`.`price`, `Tm`.`exc_price`, `Tm`.`inserted_date`, `Tm`.`update_date`, `Tm`.`downloads`, `Tm`.`type_id`, `Tm`.`is_flash`, `Tm`.`is_adult`, `Tm`.`width`, `Tm`.`author_id`, `Tm`.`is_full_site`, `Tm`.`is_real_size`, `Tm`.`keywords_en`, `Tm`.`keywords_it`, `Tm`.`description_it`, `Tm`.`description_en`, `Tm`.`software_required`, `Tm`.`sources`, `Tm`.`uri_demo`, `Tm`.`created`, `Tm`.`modified`, `TmAuthor`.`id`, `TmAuthor`.`nickname`, `TmAuthor`.`created`, `TmAuthor`.`modified`, `TmType`.`id`, `TmType`.`name` FROM `tms` AS `Tm` LEFT JOIN `tm_authors` AS `TmAuthor` ON (`Tm`.`author_id` = `TmAuthor`.`id`) LEFT JOIN `tm_types` AS `TmType` ON (`Tm`.`type_id` = `TmType`.`id`) WHERE `Tm`.`state` = 1 AND `Tm`.`id` IS NULL ORDER BY `Tm`.`id` desc LIMIT 15

SELECT DISTINCT `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` WHERE 1 = 1

107

SELECT `TmCategory`.`id`, `TmCategory`.`it`, `TmCategory`.`slug_it`, `TmCategory`.`en`, `TmCategory`.`slug_en`, `TmCategory`.`created`, `TmCategory`.`modified` FROM `tm_categories` AS `TmCategory` WHERE `TmCategory`.`it` != '' AND `id` IN (2, 56, 83, 63, 13, 3, 22, 10, 11, 14, 5, 19, 16, 7, 33, 34, 8, 23, 9, 78, 6, 25, 1, 18, 49, 42, 27, 50, 29, 21, 26, 24, 66, 35, 74, 76, 36, 47, 51, 40, 39, 4, 77, 75, 41, 43, 32, 44, 48, 65, 45, 70, 67, 46, 17, 60, 68, 53, 62, 64, 89, 54, 79, 55, 84, 81, 94, 98, 102, 93, 113, 97, 114, 80, 101, 71, 95, 72, 96, 91, 105, 92, 87, 88, 107, 109, 111, 69, 115, 61, 106, 103, 57, 100, 116, 86, 117, 112, 121, 119, 123, 122, 125, 118, 126, 138, 142) ORDER BY `TmCategory`.`it` ASC

104

SELECT DISTINCT `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` WHERE 1 = 1

107

104

SELECT DISTINCT `TmAuthor`.* FROM `tm_authors` AS `TmAuthor` LEFT JOIN `tms` AS `Tm` ON (`Tm`.`author_id` = `TmAuthor`.`id`) WHERE `Tm`.`id` IS NOT NULL ORDER BY `TmAuthor`.`nickname` ASC, `TmAuthor`.`id` ASC

135

278

SELECT count(id) AS num_Tm, `Tm`.`author_id` FROM `tms` AS `Tm` WHERE 1=1 GROUP BY author_id

140

SELECT `TmType`.`id`, `TmType`.`name` FROM `tm_types` AS `TmType` WHERE name != '' ORDER BY `name` ASC

	Adulti Affari Agricoltura Alberghi Animali Animazioni Flash Animazioni Swish Architettura Arredamento e Design Arte e Fotografia ArtWorks Auto Basso Costo Bellezza Birrerie Templates Black Templates Cellulari Templates Computer CRE Loaded template CSS Drupal Templates Dynamic Flash Dynamic Swish E-Commerce Elettronica Exterior design Famiglia Fiori Fireworks template Flash8 Fonti rinnovabili o Energie rinnovabili Forum Gallerie dinamiche in Flash Giochi Gioielli Halloween Templates Header in Flash Hosting Icone Immobiliari Incontri Industria Internet Intrattenimento Istruzione Joomla Templates jQuery Templates Legge e Diritto Libri Loghi Magento Templates Mai scaricati Mambo Templates Mangiare e Bere Matrimonio Media Medicina Militari Moda Musica Natale Templates Night Club No Profit Online Casino osCommerce template Pacchetti Template Completi Pagine Personali Papervision 3D PHP-Nuke template PhpBB2 template PhpBB3 PiÃ¹ richiesti Politica Portali Premium Templates Regali Religione Ristoranti e CaffÃ¨ San Valentino Templates Scienza Servizi di Manutenzione e Assistenza Sicurezza Siti Completi Siti in Flash Sito flash xml SocietÃ e Cultura Software Sport Stili Semplici Strumenti e accessori ferramenta SWiSHmax2 Telecomunicazioni Template a 3 Colori Template in 3D Template liquidi Templates predominanza Verde Templates a tutto schermo e ridimensionabili Trasporti Ultimi Arrivi Viaggi Web 2.0 Templates Web design Wordpress template Zen-Cart Templates

	Adonis (87 template) Eyemaster (2 template) Motoman (1 template) Aeron (17 template) Fati (22 template) Mr. Corpuscle (20 template) Alexa (12 template) Fellis (1 template) Nessy (261 template) Alice (5 template) Flasher (19 template) Neutral Nick (70 template) Alta (1 template) Flayer (428 template) Nikas (1 template) Angel (7 template) Freeze (2 template) Nuker (164 template) Arcturus (8 template) Fresh (4 template) O-zone (7 template) Ares (287 template) Frix (6 template) Oldman (378 template) ArGo (75 template) Georg (1 template) Olney (100 template) Astra (330 template) Glasgo Ranger (226 template) Omega (3 template) BG (10 template) Glenn (482 template) Orange (13 template) Big mama (1233 template) Gouty (33 template) Ostex (1 template) Blur (41 template) Hilary (74 template) Paragon (2 template) Bora (53 template) Hugo (1456 template) Pharaoh (17 template) Bruno (2 template) Hummingbird (3 template) Photographer (503 template) Bullet (17 template) Jaguar (312 template) Princess (5 template) Cactus (5 template) Jet (2 template) Pulse (1 template) Caesar (9 template) Jiro (11 template) Puma (2 template) Casher (61 template) Joker (23 template) Quill (397 template) Cerberus (489 template) Joly (10 template) Raymond (408 template) Cheetah (1 template) Jul (2 template) Ruvim (2 template) Cleric (1 template) Junior (32 template) Sebastian (22 template) Co-casher (121 template) Justin (2 template) Sharpen (16 template) Co-pharaoh (28 template) Kantrop (2 template) Shrew (11 template) Colorado (159 template) Leonardo (253 template) Sloth (3 template) Cotton (162 template) Logann (1550 template) Solus (287 template) Cougar (3 template) LogoArtist (270 template) Sonic (1 template) Cowboy (500 template) Logobaby (204 template) Southern Star (5 template) Crash (14 template) Logoman (215 template) SR (2 template) Creamy (15 template) Logotron (9 template) St. Valentine (87 template) Dan (36 template) Logotyper (1735 template) St.Nik (10 template) Dean (6 template) Logowoman (17 template) Stream (1 template) Decoy (33 template) Lovely (359 template) Strike (1 template) Delta (2365 template) Maccavelli (28 template) Svelte (511 template) Demon (41 template) MadFlasher (65 template) Tequila (10 template) Dgan Dgan (6 template) Mag (24 template) Two cows (18 template) Di (1638 template) MAN!AK (3 template) Val (89 template) Dipixel (15 template) MariArti (274 template) Vampire (142 template) Dr. Hanibal (44 template) Mary (15 template) Velvet (169 template) Dragon (4 template) Matrix (540 template) Viola (151 template) Earwig (7 template) Maxwell (533 template) Walter (7 template) Elfin (95 template) Mc Oyed (3 template) Wizard (37 template) Engine (63 template) Mercury (88 template) Wolf (3 template) Eridan (4 template) Modlin (316 template) Wuzzer (4 template) Exuma (50 template) Monet (237 template) Zim (1 template)

	Corporate Identity Mambo Templates CRE Loaded Templates Non-unique Corporate Identity Drupal Templates Non-unique Logo Templates Flash Intro Templates osCommerce Templates Flash Photo Gallery Templates PHP-Nuke Templates Flash Templates PhpBB Templates Icon Sets SWiSH Templates Joomla Templates Web Templates Logo Templates Website Templates Logosets WordPress Themes Magento Themes ZenCart Templates