Přehledy

Přehledy

Macros umí vytvářet různé přehledy, které pomáhají při rozhodování o nákupech nového zboží, nebo o přístupu k zákazníkům.

  • Přehled zboží na skladech
  • Přehledy tržeb
  • Zisk na fakturách
  • Útraty zákazníků
  • Ceny za poštovné
  • Vyčíslení slev
  • Hledaní slova
Copyright © 2011 - 2021 macros, webdesign: FormSoft s.r.o., všechna práva vyhrazena
Requests 0.096470 s
1,464.0469 kB
Benchmark Min Max Average Total
"prehledy/m698" (1)
0.098856 s
0.098856 s
0.098856 s
0.098856 s
1,488.4531 kB
1,488.4531 kB
1,488.4531 kB
1,488.4531 kB
Kohana 0.069891 s
63.9375 kB
Benchmark Min Max Average Total
find_file (90)
0.000034 s
0.004088 s
0.000777 s
0.069891 s
0.5469 kB
4.4063 kB
0.7104 kB
63.9375 kB
Database (default) 0.006155 s
130.4063 kB
Benchmark Min Max Average Total
SHOW FULL COLUMNS FROM `settings` (1)
0.000459 s
0.000459 s
0.000459 s
0.000459 s
4.4609 kB
4.4609 kB
4.4609 kB
4.4609 kB
SELECT `settings`.* FROM `settings` WHERE `settings`.`id` = 'default_title' LIMIT 1 (1)
0.000082 s
0.000082 s
0.000082 s
0.000082 s
2.9688 kB
2.9688 kB
2.9688 kB
2.9688 kB
SELECT `settings`.* FROM `settings` WHERE `settings`.`id` = 'meta_keywords' LIMIT 1 (1)
0.000048 s
0.000048 s
0.000048 s
0.000048 s
3.0781 kB
3.0781 kB
3.0781 kB
3.0781 kB
SELECT `settings`.* FROM `settings` WHERE `settings`.`id` = 'meta_description' LIMIT 1 (1)
0.000042 s
0.000042 s
0.000042 s
0.000042 s
2.9688 kB
2.9688 kB
2.9688 kB
2.9688 kB
SHOW FULL COLUMNS FROM `treemenu` (1)
0.000441 s
0.000441 s
0.000441 s
0.000441 s
4.9766 kB
4.9766 kB
4.9766 kB
4.9766 kB
SELECT `treemenu`.* FROM `treemenu` WHERE `treemenu`.`id` = '698' LIMIT 1 (4)
0.000047 s
0.000193 s
0.000090 s
0.000359 s
4.5859 kB
4.5859 kB
4.5859 kB
18.3438 kB
SHOW FULL COLUMNS FROM `articles` (1)
0.000426 s
0.000426 s
0.000426 s
0.000426 s
6.5391 kB
6.5391 kB
6.5391 kB
6.5391 kB
SELECT COUNT(*) AS `records_found` FROM `articles` JOIN `articles_treemenu` ON (`articles_treemenu`.`article_id` = `articles`.`id`) WHERE `articles_treemenu`.`treemenu_id` = '698' AND `approval` = 1 AND `visible` = 1 AND `visibility_right` IN ('all', 'not_logged') ORDER BY `articles`.`priority` DESC, `articles`.`created` DESC, `articles`.`title` ASC (1)
0.000397 s
0.000397 s
0.000397 s
0.000397 s
2.2734 kB
2.2734 kB
2.2734 kB
2.2734 kB
SELECT `articles`.* FROM `articles` JOIN `articles_treemenu` ON (`articles_treemenu`.`article_id` = `articles`.`id`) WHERE `articles_treemenu`.`treemenu_id` = '698' AND `approval` = 1 AND `visible` = 1 AND `visibility_right` IN ('all', 'not_logged') ORDER BY `articles`.`priority` DESC, `articles`.`created` DESC, `articles`.`title` ASC LIMIT 15 OFFSET 0 (1)
0.000822 s
0.000822 s
0.000822 s
0.000822 s
9.7734 kB
9.7734 kB
9.7734 kB
9.7734 kB
SHOW FULL COLUMNS FROM `articles_modules` (1)
0.000513 s
0.000513 s
0.000513 s
0.000513 s
4.9766 kB
4.9766 kB
4.9766 kB
4.9766 kB
SELECT `articles_modules`.* FROM `articles_modules` WHERE `article_id` = '563' AND `position` = 'up' AND `module_id` <> 'media' ORDER BY `module_id` ASC, `id` ASC (1)
0.000293 s
0.000293 s
0.000293 s
0.000293 s
4.6172 kB
4.6172 kB
4.6172 kB
4.6172 kB
SELECT `articles_modules`.* FROM `articles_modules` WHERE `article_id` = '563' AND `position` = 'up' AND `module_id` = 'media' ORDER BY `id` ASC (1)
0.000211 s
0.000211 s
0.000211 s
0.000211 s
4.6172 kB
4.6172 kB
4.6172 kB
4.6172 kB
SELECT `articles_modules`.* FROM `articles_modules` WHERE `article_id` = '563' AND `position` = 'down' AND `module_id` <> 'media' ORDER BY `module_id` ASC, `id` ASC (1)
0.000292 s
0.000292 s
0.000292 s
0.000292 s
4.6172 kB
4.6172 kB
4.6172 kB
4.6172 kB
SELECT `articles_modules`.* FROM `articles_modules` WHERE `article_id` = '563' AND `position` = 'down' AND `module_id` = 'media' ORDER BY `id` ASC (1)
0.000204 s
0.000204 s
0.000204 s
0.000204 s
4.6172 kB
4.6172 kB
4.6172 kB
4.6172 kB
SELECT `treemenu`.* FROM `treemenu` WHERE (`parent_id` = '0' OR `parent_id` IN (SELECT id FROM treemenu WHERE `left`<=87 AND `right`>=88)) AND `treemenu`.`id` > '0' AND `type` != 'invisible' ORDER BY `treemenu`.`left` ASC (1)
0.000523 s
0.000523 s
0.000523 s
0.000523 s
6.7422 kB
6.7422 kB
6.7422 kB
6.7422 kB
SHOW FULL COLUMNS FROM `media` (1)
0.000359 s
0.000359 s
0.000359 s
0.000359 s
4.9766 kB
4.9766 kB
4.9766 kB
4.9766 kB
SELECT `media`.* FROM `media` WHERE `media`.`id` = '0' LIMIT 1 (1)
0.000053 s
0.000053 s
0.000053 s
0.000053 s
4.3984 kB
4.3984 kB
4.3984 kB
4.3984 kB
SELECT `treemenu`.* FROM `treemenu` WHERE `treemenu`.`id` > '0' AND `type` != 'invisible' ORDER BY `treemenu`.`left` ASC (2)
0.000072 s
0.000087 s
0.000080 s
0.000159 s
11.3281 kB
11.3281 kB
11.3281 kB
22.6563 kB
SHOW FULL COLUMNS FROM `routes` (1)
0.000371 s
0.000371 s
0.000371 s
0.000371 s
4.5078 kB
4.5078 kB
4.5078 kB
4.5078 kB
SELECT `routes`.* FROM `routes` WHERE `type` = 'menu' (1)
0.000050 s
0.000050 s
0.000050 s
0.000050 s
3.3984 kB
3.3984 kB
3.3984 kB
3.3984 kB
SELECT `settings`.* FROM `settings` WHERE `settings`.`id` = 'view_counter' LIMIT 1 (1)
0.000052 s
0.000052 s
0.000052 s
0.000052 s
4.8984 kB
4.8984 kB
4.8984 kB
4.8984 kB
Application Execution (176) 0.105060 s 0.511497 s 0.149356 s 0.191365 s
1,532.4688 kB 2,278.6797 kB 1,991.1709 kB 2,002.4844 kB