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 43 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`40402
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 887
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 884
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 552
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` <= '2022-05-25 05:08:30' AND `Advertisement`.`valid_to` >= '2022-05-25 05:08:30' 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)12
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`) 15152
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` = 20812
30SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE `Category`.`id` = 1 LIMIT 1110
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 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