Štatistiky OCSK - marec-december 2013

fotka

Rok 2013 sa nám pomaly, ale isto končí, no a tak by sa patrilo zhodnotiť dianie na servri Opelclubu.
Dňa 13.03.2013 došlo k zmene, na ktorú sa už nejaký ten čas čakalo.
Tou zmenou bola nová podoba samotného fóra, na ktorom sa odohráva drvivá väčšina udalostí z nášho klubu fanúšikov značky OPEL.

Pre užívateľov to znamenalo viac možností pri zverejňovaní svojich príspevkov. Taktiež sa inovoval systém, na ktorom fórum funguje a to na (vtedy) najaktuálnejšiu verziu PHPBB3. Pre administrátorov a moderátorov sa sprístupnili omnoho pokročilejšie funkcie uľahčujúce ich prácu. Spolu s novým fórom a zmenou webhostingu na Websupport.sk, bolo vynovené aj samotné logo Opelclubu.

Za tento čas sa nazbierali nejaké tie údaje, pomocou Google analytics, takže na týchto linkoch je možné vidieť, akým spôsobom sa menila návštevnosť stránok, ale aj ďalšie štatistické doplnky.

Snahou Opelclubu je v najbližšej dobe tieto čísla návštevnosti a tiež počet registrovaných členov klubu navýšiť a to krokmi, ktoré sú zatiaľ v pokročilejšom štádiu príprav. Veríme, že zmeny, ktoré nastanú, budú značku Opelclub.sk dostávať do pozornosti nových ľudí a potencionálnych reklamných partnerov.


Návštevnosť - pravidelní vs. noví užívatelia

Prehliadače a operačné systémy užívateľov

Zariadenia, z ktorých sa na stránku pripájate

Koľko stránok užívateľ otvoril

Ako často si užívatelia prezerajú stránky

Odkiaľ sa ľudia prihlasujú

Z akej siete sa ľudia prihlasujú

Prehľad

Návštevnosť jednotlivých podstránok

Rýchlosť načítavania stránok

Rýchlosť načítavania stránok-časť 2.

Doba zotrvania na stránkach


(default) 34 queries took 42 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `pages`16161
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';111
3SHOW FULL COLUMNS FROM `users`12121
4SHOW FULL COLUMNS FROM `partners`16161
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
6SHOW FULL COLUMNS FROM `memberinfos`40402
7SHOW FULL COLUMNS FROM `ranks`224
8SHOW FULL COLUMNS FROM `paymentmethods`441
9SHOW FULL COLUMNS FROM `membercars`17171
10SHOW FULL COLUMNS FROM `fueltypes`441
11SHOW FULL COLUMNS FROM `transmissions`442
12SHOW FULL COLUMNS FROM `axles`441
13SHOW FULL COLUMNS FROM `vipcards`882
14SHOW FULL COLUMNS FROM `categories`10101
15SHOW FULL COLUMNS FROM `attachments`771
16SHOW FULL COLUMNS FROM `attachments_pages`331
17SHOW FULL COLUMNS FROM `menuitems`13131
18SHOW FULL COLUMNS FROM `menus`551
19SHOW FULL COLUMNS FROM `settings`551
20SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1 111
21SELECT `Page`.`id`, `Page`.`content`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`is_highlight` = 1 AND `Page`.`status` != 3 ORDER BY `Page`.`modified` desc 883
22SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` IN (274, 257, 261, 258, 256, 198, 195, 197) AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`) 001
23SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`title`, `Menuitem`.`url`, `Menuitem`.`parent_id`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`status`, `Menuitem`.`emph`, `Menuitem`.`is_category_list`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `menuitems` AS `Menuitem` LEFT JOIN `menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) WHERE `Menuitem`.`menu_id` = 2 AND `Menuitem`.`status` != 3 ORDER BY `Menuitem`.`sort` asc 881
24SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `categories` AS `Category` WHERE `Category`.`status` != 3 AND `Category`.`show_in_menu` = 1 551
25SHOW FULL COLUMNS FROM `adpositions`991
26SHOW FULL COLUMNS FROM `advertisements`13131
27SELECT `Adposition`.`id`, `Adposition`.`title`, `Adposition`.`comment`, `Adposition`.`position_width`, `Adposition`.`position_height`, `Adposition`.`ad_width`, `Adposition`.`ad_height`, `Adposition`.`visible_ads_count`, `Adposition`.`status` FROM `adpositions` AS `Adposition` WHERE `Adposition`.`status` = 1 221
28SELECT `Advertisement`.`id`, `Advertisement`.`adposition_id`, `Advertisement`.`partner_id`, `Advertisement`.`valid_from`, `Advertisement`.`valid_to`, `Advertisement`.`saved_filename`, `Advertisement`.`alt`, `Advertisement`.`url`, `Advertisement`.`status`, `Advertisement`.`display_count`, `Advertisement`.`click_count`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`valid_from` <= '2021-09-19 22:29:01' AND `Advertisement`.`valid_to` >= '2021-09-19 22:29:01' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC 111
29UPDATE `advertisements` AS `Advertisement` LEFT JOIN `adpositions` AS `Adposition` ON (`Advertisement`.`adposition_id` = `Adposition`.`id`) SET `Advertisement`.`display_count` = Advertisement.display_count + 1 WHERE `Advertisement`.`id` = (17)12
30SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`page_type`, `Page`.`layout_id`, `Page`.`title`, `Page`.`content`, `Page`.`status`, `Page`.`is_highlight`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`user_id`, `Page`.`vip_only`, `Page`.`created`, `Page`.`modified`, `Page`.`view_count`, `Page`.`old_author_id`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified`, `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`id` = 196 AND `Page`.`status` = 1 LIMIT 1111
31SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` = 196 AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`) 000
32UPDATE `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) SET `Page`.`view_count` = Page.view_count + 1 WHERE `Page`.`id` = 19612
33SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`id` = 25 LIMIT 1110
34SELECT `Category`.`id`, `Category`.`title` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 49 AND `Category`.`rght` >= 50 ORDER BY `Category`.`lft` asc 110
(forum) 5 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `phpbb_posts`26263
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
4SHOW FULL COLUMNS FROM `phpbb_topics`34343
5SHOW FULL COLUMNS FROM `phpbb_forums`42422