Na stiahnutie


Prílohy

new-op-com -139-software.rar (5836634 b)
OP-COM-chinaclone2010.zip (7370093 b)
Audience Overview visits vs.new.pdf (197167 b)
Browser & OS.pdf (177509 b)
Devices.pdf (302566 b)
Engagement.pdf (152252 b)
Frequency & Recency.pdf (153580 b)
Location.pdf (250243 b)
Network.pdf (1926753 b)
New vs Returning.pdf (136573 b)
Overview.pdf (116877 b)
Pages.pdf (1983436 b)
Site Speed Page Timings1.pdf (168122 b)
Site Speed Page Timings2.pdf (166671 b)
visit duration Engagement.pdf (152237 b)

Software OPCOM 2010 china

Znak OCSK:

štatistiky OCSK 2013

štatistiky OCSK 2014

 

 


(default) 31 queries took 36 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';111
6SHOW FULL COLUMNS FROM `memberinfos`40401
7SHOW FULL COLUMNS FROM `ranks`221
8SHOW FULL COLUMNS FROM `paymentmethods`441
9SHOW FULL COLUMNS FROM `membercars`17171
10SHOW FULL COLUMNS FROM `fueltypes`441
11SHOW FULL COLUMNS FROM `transmissions`441
12SHOW FULL COLUMNS FROM `axles`441
13SHOW FULL COLUMNS FROM `vipcards`881
14SHOW FULL COLUMNS FROM `attachments`771
15SHOW FULL COLUMNS FROM `attachments_pages`331
16SHOW FULL COLUMNS FROM `settings`551
17SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1 111
18SELECT `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 885
19SELECT `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
20SELECT `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 882
21SELECT `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
22SHOW FULL COLUMNS FROM `adpositions`991
23SHOW FULL COLUMNS FROM `advertisements`13131
24SELECT `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
25SELECT `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` <= '2023-04-02 07:04:59' AND `Advertisement`.`valid_to` >= '2023-04-02 07:04:59' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC 111
26UPDATE `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)11
27SELECT `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` = 208 AND `Page`.`status` = 1 LIMIT 1111
28SELECT `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` = 208 AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`) 15151
29UPDATE `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` = 20811
30SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`id` = 1 LIMIT 1111
31SELECT `Category`.`id`, `Category`.`title` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 1 AND `Category`.`rght` >= 6 ORDER BY `Category`.`lft` asc 111
(forum) 5 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `phpbb_posts`26262
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`34341
5SHOW FULL COLUMNS FROM `phpbb_forums`42421