Увага! Інформація для споживачів електричної енергії!

page	1
pgt     0.12 sec.

memory  623.78 Kb.
peak    987.83 Kb.
layout  agent.layouts/content
params  Array
(
    [id] => 645
)
            

Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41' LIMIT 1
        ;
Time: 0.000332
Affected rows: 0



Query: SELECT * FROM `tins_aliases` WHERE `alias` = '/uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41' OR `alias` = '/uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41/' LIMIT 1;
Time: 0.000309
Affected rows: 1



Query: SELECT * FROM `tins_aliases` WHERE `alias` = '/agent_content/browse/id:645/' OR `alias` = '/agent_content/browse/id:645' LIMIT 1;
Time: 0.000230
Affected rows: 0



Query: SELECT * FROM agent_content WHERE `uniqid`='645' LIMIT 1;
Time: 0.000351
Affected rows: 0



Query: SELECT * FROM agent_content WHERE `id`='645' LIMIT 1;
Time: 0.000251
Affected rows: 1



Query: SELECT * FROM agent_sites WHERE `id`='1' LIMIT 1;
Time: 0.000389
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000351
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000188
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000164
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000162
Affected rows: 0



Query: /* widgetAgent->categories() */
            SELECT
                
                cat1.`title` AS `cat1Title`,
                cat1.`id` AS `cat1Id`,
                cat1.`type` AS `cat1Type`,
                cat1.`body` AS `cat1Body`,
                cat1Rel.`rel_id` AS `cat1rel_id`,
                cat1.`contents_count` AS `cat1ContentsCount`
            
            FROM
                /* first level */
                  `agent_categories_rel` AS cat1Rel
                JOIN
                    `agent_categories` AS cat1
                  ON
                    cat1.`id` = cat1Rel.`category_id`
                    AND cat1.`type` IN (2)
                
            
            
            ORDER BY cat1.`contents_count` DESC
            LIMIT 8
        ;
Time: 0.000297
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000177
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 645
                ;
Time: 0.000206
Affected rows: 0



Query: 
            /*
                agentWidget->contents()
                host: vechirka.com.ua
                url: /uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41
                args: Array
		(
		    [queries] => Array
		        (
		            [0] => `active` = 1
		            [1] => `id` < 645
		        )
		
		    [total] => 
		    [view] => agent.views/preview_content_next
		    [thumbnails] => 1
		    [order] => `id` ASC
		    [limit] => 3
		)
		
            */
            SELECT
                
                
                entity.*
            FROM
            `agent_content` AS entity
            
             WHERE 
		`active` = 1
		AND
		`id` < 645
            
            ORDER BY `id` ASC
            LIMIT 3
        ;
Time: 0.000302
Affected rows: 3



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:1/' LIMIT 1
        ;
Time: 0.000229
Affected rows: 1



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:18/' LIMIT 1
        ;
Time: 0.000201
Affected rows: 1



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:20/' LIMIT 1
        ;
Time: 0.000192
Affected rows: 1



Query: 
            /*
                agentWidget->contents()
                host: vechirka.com.ua
                url: /uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41
                args: Array
		(
		    [queries] => Array
		        (
		            [0] => `active` = 1
		            [1] => `id` > 645
		        )
		
		    [total] => 
		    [view] => agent.views/preview_content_next
		    [thumbnails] => 1
		    [order] => `id` ASC
		    [limit] => 3
		)
		
            */
            SELECT
                
                
                entity.*
            FROM
            `agent_content` AS entity
            
             WHERE 
		`active` = 1
		AND
		`id` > 645
            
            ORDER BY `id` ASC
            LIMIT 3
        ;
Time: 0.000298
Affected rows: 3



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:646/' LIMIT 1
        ;
Time: 0.000194
Affected rows: 1



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:647/' LIMIT 1
        ;
Time: 0.000188
Affected rows: 1



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:648/' LIMIT 1
        ;
Time: 0.000184
Affected rows: 1



Query: 
            /*
                agentWidget->contents()
                host: vechirka.com.ua
                url: /uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41
                args: Array
		(
		    [queries] => Array
		        (
		            [0] => `active` = 1
		        )
		
		    [total] => 
		    [order] => `date_added` DESC
		    [view] => agent.views/preview_content_recent
		    [limit] => 10
		)
		
            */
            SELECT
                
                
                entity.*
            FROM
            `agent_content` AS entity
            
             WHERE 
		`active` = 1
            
            ORDER BY `date_added` DESC
            LIMIT 10
        ;
Time: 0.047956
Affected rows: 10



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7099/' LIMIT 1
        ;
Time: 0.000460
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7099
                ;
Time: 0.000233
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7113/' LIMIT 1
        ;
Time: 0.000279
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7113
                ;
Time: 0.000196
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7110/' LIMIT 1
        ;
Time: 0.000213
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7110
                ;
Time: 0.000183
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7114/' LIMIT 1
        ;
Time: 0.000219
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7114
                ;
Time: 0.000181
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7107/' LIMIT 1
        ;
Time: 0.000278
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7107
                ;
Time: 0.000218
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7108/' LIMIT 1
        ;
Time: 0.000274
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7108
                ;
Time: 0.000218
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7102/' LIMIT 1
        ;
Time: 0.000213
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7102
                ;
Time: 0.000206
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7100/' LIMIT 1
        ;
Time: 0.000325
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7100
                ;
Time: 0.000289
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7101/' LIMIT 1
        ;
Time: 0.000321
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7101
                ;
Time: 0.000285
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:7112/' LIMIT 1
        ;
Time: 0.000316
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7112
                ;
Time: 0.000285
Affected rows: 0



Query: 
            /*
                agentWidget->contents()
                host: vechirka.com.ua
                url: /uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41
                args: Array
		(
		    [queries] => Array
		        (
		            [0] => id IN (46, 84, 110)
		        )
		
		    [view] => agent.views/preview_content_recent
		)
		
            */
            SELECT
                SQL_CALC_FOUND_ROWS
                
                entity.*
            FROM
            `agent_content` AS entity
            
             WHERE 
		id IN (46, 84, 110)
            
            
            
        ;
Time: 0.000530
Affected rows: 3



Query: 
                /* agentWidget->contents() */
                SELECT FOUND_ROWS() AS `count`;
            
Time: 0.000177
Affected rows: 1



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:46/' LIMIT 1
        ;
Time: 0.000393
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 46
                ;
Time: 0.000315
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:84/' LIMIT 1
        ;
Time: 0.000322
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 84
                ;
Time: 0.000286
Affected rows: 0



Query: 
            SELECT
                
                *
            FROM
                `tins_aliases`
             WHERE `origin` = '/agent_content/browse/id:110/' LIMIT 1
        ;
Time: 0.000329
Affected rows: 1



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 110
                ;
Time: 0.000290
Affected rows: 0



Query: 
            /*
                agentWidget->contents()
                host: vechirka.com.ua
                url: /uvaga-nformac-ya-dlya-spozhivach-v-elektrichno-energ-41
                args: Array
		(
		    [queries] => Array
		        (
		            [0] => `active` = 1
		        )
		
		    [total] => 
		    [order] => `date_added` DESC
		    [view] => agent.views/preview_content_recent
		    [limit] => 3
		)
		
            */
            SELECT
                
                
                entity.*
            FROM
            `agent_content` AS entity
            
             WHERE 
		`active` = 1
            
            ORDER BY `date_added` DESC
            LIMIT 3
        ;
Time: 0.042069
Affected rows: 3



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7099
                ;
Time: 0.000346
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7113
                ;
Time: 0.000213
Affected rows: 0



Query: 
                SELECT
                    category.*
                FROM
                    `agent_content_rel` AS rel
                    JOIN
                    `agent_categories` AS category
                    ON
                    category.id = rel.`parent_category_id`
                WHERE
                    rel.`content_id` = 7110
                ;
Time: 0.000182
Affected rows: 0



Query: /* widgetAgent->categories() */
            SELECT
                
                cat1.`title` AS `cat1Title`,
                cat1.`id` AS `cat1Id`,
                cat1.`type` AS `cat1Type`,
                cat1.`body` AS `cat1Body`,
                cat1Rel.`rel_id` AS `cat1rel_id`,
                cat1.`contents_count` AS `cat1ContentsCount`
            
            FROM
                /* first level */
                  `agent_categories_rel` AS cat1Rel
                JOIN
                    `agent_categories` AS cat1
                  ON
                    cat1.`id` = cat1Rel.`category_id`
                    AND cat1.`type` IN (3)
                
            
            GROUP BY cat1.`id`
            ORDER BY cat1.`contents_count` DESC
            LIMIT 20
        ;
Time: 0.000434
Affected rows: 0