Siti Web Pronti by SR

0 of 1

18 queries took 197 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `tms`	23	23	7
2	DESCRIBE `tm_categories`	7	7	5
3	DESCRIBE `tm_authors`	4	4	5
4	DESCRIBE `tm_styles`	2	2	4
5	DESCRIBE `tm_screenshots`	8	8	5
6	DESCRIBE `tm_assoc_categories`	3	3	5
7	DESCRIBE `tm_assoc_styles`	3	3	4
8	DESCRIBE `tm_types`	2	2	4
9	DESCRIBE `tm_views`	5	5	5
10	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 `TmAuthor`.`nickname` = ('SR')	1	1	60
11	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 `TmAuthor`.`nickname` = ('SR') ORDER BY `Tm`.`id` desc LIMIT 15	0	0	85
12	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	1
13	SELECT count(id) AS num_Tm, `Tm`.`author_id` FROM `tms` AS `Tm` WHERE 1=1 GROUP BY author_id	140	140	1
14	SELECT DISTINCT `TmAssocCategory`.`tm_category_id` FROM `tm_assoc_categories` AS `TmAssocCategory` WHERE 1 = 1	107	107	1
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 `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	1
17	SELECT count(id) AS num_Tm, `Tm`.`author_id` FROM `tms` AS `Tm` WHERE 1=1 GROUP BY author_id	140	140	1
18	SELECT `TmType`.`id`, `TmType`.`name` FROM `tm_types` AS `TmType` WHERE name != '' ORDER BY `name` ASC	22	22	1

18 queries took 197 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 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 `TmAuthor`.`nickname` = ('SR')

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 `TmAuthor`.`nickname` = ('SR') ORDER BY `Tm`.`id` desc LIMIT 15

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

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

140

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

135

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