Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Language`.`locale`, `Language`.`title` FROM `autorino_production`.`languages` AS `Language` WHERE `locale` IN ('eng', 'rus', 'ukr') | 1 | 1 | 0 | |
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `autorino_production`.`sessions` AS `Session` WHERE `id` = '2tdp6qbo110va8rl25cn2d0et3' LIMIT 1 | 0 | 0 | 0 | |
SELECT `AclAco`.`id`, `AclAco`.`parent_id`, `AclAco`.`model`, `AclAco`.`foreign_key`, `AclAco`.`alias`, `AclAco`.`lft`, `AclAco`.`rght` FROM `autorino_production`.`acos` AS `AclAco` WHERE `AclAco`.`parent_id` IS NOT NULL ORDER BY `AclAco`.`lft` asc | 372 | 372 | 0 | |
SELECT `AclAro`.`id`, `AclAro`.`parent_id`, `AclAro`.`model`, `AclAro`.`foreign_key`, `AclAro`.`alias`, `AclAro`.`lft`, `AclAro`.`rght` FROM `autorino_production`.`aros` AS `AclAro` WHERE `AclAro`.`model` = 'Role' AND `AclAro`.`foreign_key` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AclPermission`.`id`, `AclPermission`.`aco_id` FROM `autorino_production`.`aros_acos` AS `AclPermission` WHERE `AclPermission`.`aro_id` = 2 AND `AclPermission`.`aco_id` IN (83, 84, 85, 466, 5, 468, 20, 22, 23, 24, 474, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 333, 479, 99, 101, 102, 103, 409, 410, 480, 511, 42, 43, 481, 45, 46, 47, 48, 49, 482, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 483, 87, 89, 90, 91, 193, 194, 408, 471, 509, 510, 95, 96, 97, 472, 106, 496, 219, 220, 221, 222, 284, 295, 399, 400, 592, 228, 229, 495, 257, 258, 259, 260, 261, 318, 319, 501, 264, 265, 266, 268, 269, 270, 271, 317, 320, 426, 492, 493, 275, 276, 278, 279, 280, 281, 282, 283, 494, 286, 476, 289, 290, 291, 292, 293, 294, 477, 309, 497, 311, 498, 321, 332, 473, 546, 547, 325, 326, 327, 328, 329, 330, 331, 467, 336, 337, 338, 339, 340, 422, 484, 342, 343, 344, 345, 486, 347, 348, 349, 350, 487, 352, 353, 354, 355, 356, 357, 358, 359, 360, 488, 362, 364, 365, 366, 489, 368, 369, 370, 371, 372, 373, 374, 403, 490, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 404, 414, 420, 491, 638, 659, 660, 665, 641, 642, 658, 661, 662, 663, 664, 644, 645, 646, 648, 650, 651, 652, 653, 654, 655, 656, 657, 407, 470, 412, 469, 504, 505, 506, 507, 508, 514, 515, 516, 517, 518, 519, 520, 523, 524, 525, 526, 539, 540, 542, 544, 576, 577, 610, 611, 612, 613, 579, 581, 582, 583, 584, 606, 607, 608, 609, 647, 618, 619, 620, 621, 624, 625, 626, 627, 628, 629, 631, 632, 633, 634, 635, 636, 637) AND `AclPermission`.`_create` = '1' AND `AclPermission`.`_read` = '1' AND `AclPermission`.`_update` = '1' AND `AclPermission`.`_delete` = '1' | 47 | 47 | 0 | |
SELECT `Block`.`id`, `Block`.`slug` FROM `autorino_production`.`blocks` AS `Block` WHERE `Block`.`widget_count` > 0 | 6 | 6 | 0 | |
SELECT `Widget`.`id`, `Widget`.`block_id`, `Widget`.`parent_id`, `Widget`.`title`, `Widget`.`slug`, `Widget`.`widget`, `Widget`.`text`, `Widget`.`state`, `Widget`.`lft`, `Widget`.`rght`, `Widget`.`created`, `Widget`.`modified`, `Widget`.`admin`, `Widget`.`params`, `Widget`.`visibility`, `Widget`.`visible_on` FROM `autorino_production`.`widgets` AS `Widget` WHERE `Widget`.`block_id` IN (1, 3, 4, 5, 6, 7) AND `Widget`.`state` = '1' AND `Widget`.`admin` = '0' AND ((((`Widget`.`visibility` = 'all') AND (`Widget`.`visible_on` = ''))) OR (((`Widget`.`visibility` = 'contain') AND (((`Widget`.`visible_on` LIKE '%\"/adverts/transport-vodnii-transport\"%') OR (`Widget`.`visible_on` LIKE '%\"controller:vehicles/action:index\"%'))))) OR (((`Widget`.`visibility` = 'except') AND (`Widget`.`visible_on` NOT LIKE '%\"/adverts/transport-vodnii-transport\"%') AND (`Widget`.`visible_on` NOT LIKE '%\"controller:vehicles/action:index\"%')))) ORDER BY `Widget`.`lft` ASC | 6 | 6 | 1 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`slug`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`link_count` FROM `autorino_production`.`menus` AS `Menu` WHERE `Menu`.`link_count` > 0 | 2 | 2 | 0 | |
SELECT `Link`.`id`, `Link`.`menu_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`link`, `Link`.`created`, `Link`.`modified`, `Link`.`homepage`, `Link`.`state`, `Link`.`lft`, `Link`.`rght`, `Link`.`params` FROM `autorino_production`.`links` AS `Link` WHERE `Link`.`menu_id` = 1 AND `Link`.`state` = '1' ORDER BY `Link`.`lft` ASC | 18 | 18 | 0 | |
SELECT `Link`.`id`, `Link`.`menu_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`link`, `Link`.`created`, `Link`.`modified`, `Link`.`homepage`, `Link`.`state`, `Link`.`lft`, `Link`.`rght`, `Link`.`params` FROM `autorino_production`.`links` AS `Link` WHERE `Link`.`menu_id` = 2 AND `Link`.`state` = '1' ORDER BY `Link`.`lft` ASC | 8 | 8 | 15 | maybe slow |
SELECT `Transport`.`id`, `Transport`.`parent_id`, `Transport`.`lft`, `Transport`.`rght`, `Transport`.`title`, `Transport`.`slug`, `Transport`.`vehicle_count` FROM `autorino_production`.`transports` AS `Transport` WHERE `Transport`.`slug` = 'vodnii-transport' ORDER BY `Transport`.`lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Transport`.`lft`, `Transport`.`rght` FROM `autorino_production`.`transports` AS `Transport` WHERE 1 = 1 AND `Transport`.`id` = 4 ORDER BY `Transport`.`lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Transport`.`id`, `Transport`.`slug` FROM `autorino_production`.`transports` AS `Transport` WHERE 1 = 1 AND `Transport`.`rght` < 110 AND `Transport`.`lft` > 89 ORDER BY `Transport`.`lft` asc | 10 | 10 | 2 | maybe slow |
SELECT `Transport`.`id`, `Transport`.`parent_id`, `Transport`.`lft`, `Transport`.`rght`, `Transport`.`title`, `Transport`.`slug`, `Transport`.`vehicle_count` FROM `autorino_production`.`transports` AS `Transport` WHERE `Transport`.`id` IN (53, 54, 55, 56, 57, 58, 59, 60, 61, 62) ORDER BY `Transport`.`lft` ASC | 10 | 10 | 18 | maybe slow |
SELECT `Brand`.`id`, `Brand`.`title`, `Brand`.`slug`, `Brand`.`vehicle_count` FROM `autorino_production`.`brands` AS `Brand` inner JOIN `autorino_production`.`brands_transports` AS `BrandsTransports` ON (`Brand`.`id` = `BrandsTransports`.`brand_id`) inner JOIN `autorino_production`.`transports` AS `Transport` ON (`BrandsTransports`.`transport_id` = `Transport`.`id`) WHERE `Transport`.`id` IN (53, 54, 55, 56, 57, 58, 59, 60, 61, 62) ORDER BY `Brand`.`title` ASC | 2736 | 2736 | 111 | |
SELECT `Vehicle`.`id`, `Vehicle`.`state_id`, `Vehicle`.`city_id`, `Vehicle`.`transport_root_id`, `Vehicle`.`transport_id`, `Vehicle`.`brand_id`, `Vehicle`.`mark_id`, `Vehicle`.`drive_id`, `Vehicle`.`transmission_id`, `Vehicle`.`fuel_id`, `Vehicle`.`slug`, `Vehicle`.`version`, `Vehicle`.`vin`, `Vehicle`.`doors`, `Vehicle`.`color`, `Vehicle`.`year`, `Vehicle`.`running`, `Vehicle`.`engine`, `Vehicle`.`price`, `Vehicle`.`currency`, `Vehicle`.`description`, `Vehicle`.`is_hot`, `Vehicle`.`hits`, `Vehicle`.`created`, `Vehicle`.`created_by`, `Vehicle`.`modified`, `Vehicle`.`modified_by`, `Vehicle`.`state`, `Vehicle`.`publish_up`, `Vehicle`.`publish_down`, `Vehicle`.`params`, `Vehicle`.`is_metallic`, `Vehicle`.`consumption_city`, `Vehicle`.`consumption_highway`, `Vehicle`.`consumption_mixed`, `Vehicle`.`power`, `Vehicle`.`power_unit`, `Vehicle`.`is_new`, `Vehicle`.`in_archive`, `Vehicle`.`is_sold`, `Creator`.`id`, `Creator`.`role_id`, `Creator`.`username`, `Creator`.`password`, `Creator`.`email`, `Creator`.`created`, `Creator`.`modified`, `Creator`.`last_entry`, `Creator`.`active`, `Creator`.`activation_code`, `Creator`.`update_required`, `Creator`.`profile`, `Creator`.`params`, `City`.`id`, `City`.`state_id`, `City`.`title`, `City`.`slug`, `Brand`.`id`, `Brand`.`title`, `Brand`.`slug`, `Brand`.`vehicle_count`, `Mark`.`id`, `Mark`.`brand_id`, `Mark`.`transport_id`, `Mark`.`parent_id`, `Mark`.`lft`, `Mark`.`rght`, `Mark`.`title`, `Mark`.`slug`, `Mark`.`vehicle_count`, `Drive`.`id`, `Drive`.`title`, `Drive`.`slug`, `Drive`.`vehicle_count`, `Transmission`.`id`, `Transmission`.`title`, `Transmission`.`slug`, `Transmission`.`vehicle_count`, `Fuel`.`id`, `Fuel`.`title`, `Fuel`.`slug`, `Fuel`.`vehicle_count` FROM `autorino_production`.`vehicles` AS `Vehicle` LEFT JOIN `autorino_production`.`users` AS `Creator` ON (`Vehicle`.`created_by` = `Creator`.`id`) LEFT JOIN `autorino_production`.`cities` AS `City` ON (`Vehicle`.`city_id` = `City`.`id`) LEFT JOIN `autorino_production`.`brands` AS `Brand` ON (`Vehicle`.`brand_id` = `Brand`.`id`) LEFT JOIN `autorino_production`.`marks` AS `Mark` ON (`Vehicle`.`mark_id` = `Mark`.`id`) LEFT JOIN `autorino_production`.`drives` AS `Drive` ON (`Vehicle`.`drive_id` = `Drive`.`id`) LEFT JOIN `autorino_production`.`transmissions` AS `Transmission` ON (`Vehicle`.`transmission_id` = `Transmission`.`id`) LEFT JOIN `autorino_production`.`fuels` AS `Fuel` ON (`Vehicle`.`fuel_id` = `Fuel`.`id`) WHERE `Vehicle`.`state` = '1' AND `in_archive` = '0' LIMIT 10 | 6 | 6 | 0 | |
SELECT `Media`.`id`, `Media`.`foreign_id`, `Media`.`model`, `Media`.`attachment_content_type`, `Media`.`attachment_file_name`, `Media`.`attachment_file_size`, `Media`.`title`, `Media`.`state`, `Media`.`main`, `Media`.`created`, `Media`.`modified` FROM `autorino_production`.`attachments` AS `Media` WHERE `model` = 'Vehicle' AND `Media`.`foreign_id` IN (72, 75, 77, 79, 80, 81) | 2 | 2 | 0 | |
SELECT COUNT(*) AS `count` FROM `autorino_production`.`vehicles` AS `Vehicle` LEFT JOIN `autorino_production`.`users` AS `Creator` ON (`Vehicle`.`created_by` = `Creator`.`id`) LEFT JOIN `autorino_production`.`cities` AS `City` ON (`Vehicle`.`city_id` = `City`.`id`) LEFT JOIN `autorino_production`.`brands` AS `Brand` ON (`Vehicle`.`brand_id` = `Brand`.`id`) LEFT JOIN `autorino_production`.`marks` AS `Mark` ON (`Vehicle`.`mark_id` = `Mark`.`id`) LEFT JOIN `autorino_production`.`drives` AS `Drive` ON (`Vehicle`.`drive_id` = `Drive`.`id`) LEFT JOIN `autorino_production`.`transmissions` AS `Transmission` ON (`Vehicle`.`transmission_id` = `Transmission`.`id`) LEFT JOIN `autorino_production`.`fuels` AS `Fuel` ON (`Vehicle`.`fuel_id` = `Fuel`.`id`) WHERE `Vehicle`.`state` = '1' AND `in_archive` = '0' | 1 | 1 | 13 | maybe slow |
SELECT `Transport`.`id`, `Transport`.`parent_id`, `Transport`.`lft`, `Transport`.`rght`, `Transport`.`title`, `Transport`.`slug`, `Transport`.`vehicle_count` FROM `autorino_production`.`transports` AS `Transport` WHERE `Transport`.`parent_id` = 0 ORDER BY `Transport`.`lft` ASC | 12 | 12 | 0 | |
SELECT `Article`.`id`, `Article`.`category_id`, `Article`.`title`, `Article`.`slug`, `Article`.`subtitle`, `Article`.`text`, `Article`.`state`, `Article`.`featured`, `Article`.`created`, `Article`.`created_by`, `Article`.`modified`, `Article`.`modified_by`, `Article`.`publish_up`, `Article`.`publish_down`, `Article`.`visits`, `Article`.`params`, `PrimaryCategory`.`id`, `PrimaryCategory`.`parent_id`, `PrimaryCategory`.`lft`, `PrimaryCategory`.`rght`, `PrimaryCategory`.`title`, `PrimaryCategory`.`slug`, `PrimaryCategory`.`description`, `PrimaryCategory`.`state`, `PrimaryCategory`.`created`, `PrimaryCategory`.`created_by`, `PrimaryCategory`.`modified`, `PrimaryCategory`.`modified_by`, `PrimaryCategory`.`params`, `Creator`.`id`, `Creator`.`role_id`, `Creator`.`username`, `Creator`.`password`, `Creator`.`email`, `Creator`.`created`, `Creator`.`modified`, `Creator`.`last_entry`, `Creator`.`active`, `Creator`.`activation_code`, `Creator`.`update_required`, `Creator`.`profile`, `Creator`.`params`, `Modifier`.`id`, `Modifier`.`role_id`, `Modifier`.`username`, `Modifier`.`password`, `Modifier`.`email`, `Modifier`.`created`, `Modifier`.`modified`, `Modifier`.`last_entry`, `Modifier`.`active`, `Modifier`.`activation_code`, `Modifier`.`update_required`, `Modifier`.`profile`, `Modifier`.`params` FROM `autorino_production`.`articles` AS `Article` inner JOIN `autorino_production`.`categories_articles` AS `CategoriesArticle` ON (`CategoriesArticle`.`article_id` = `Article`.`id`) inner JOIN `autorino_production`.`categories` AS `Category` ON (`Category`.`id` = `CategoriesArticle`.`category_id`) LEFT JOIN `autorino_production`.`categories` AS `PrimaryCategory` ON (`Article`.`category_id` = `PrimaryCategory`.`id`) LEFT JOIN `autorino_production`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `autorino_production`.`users` AS `Modifier` ON (`Article`.`modified_by` = `Modifier`.`id`) WHERE `Article`.`state` = '1' AND `Category`.`id` = 5 ORDER BY `Article`.`publish_up` DESC LIMIT 4 | 4 | 4 | 0 | |
SELECT `Media`.`id`, `Media`.`foreign_id`, `Media`.`model`, `Media`.`attachment_content_type`, `Media`.`attachment_file_name`, `Media`.`attachment_file_size`, `Media`.`title`, `Media`.`state`, `Media`.`main`, `Media`.`created`, `Media`.`modified` FROM `autorino_production`.`attachments` AS `Media` WHERE `model` = 'Article' AND `Media`.`foreign_id` IN (275, 276, 277, 274) | 0 | 0 | 0 | |
SELECT `Comment`.`id`, `Comment`.`foreign_model`, `Comment`.`foreign_id`, `Comment`.`user_id`, `Comment`.`author_ip`, `Comment`.`author_name`, `Comment`.`author_email`, `Comment`.`author_website`, `Comment`.`content`, `Comment`.`created` FROM `autorino_production`.`comments` AS `Comment` WHERE `Comment`.`foreign_model` = 'Article' AND `Comment`.`foreign_id` IN (275, 276, 277, 274) | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`title`, `Category`.`slug`, `Category`.`description`, `Category`.`state`, `Category`.`created`, `Category`.`created_by`, `Category`.`modified`, `Category`.`modified_by`, `Category`.`params`, `CategoriesArticle`.`id`, `CategoriesArticle`.`category_id`, `CategoriesArticle`.`article_id` FROM `autorino_production`.`categories` AS `Category` JOIN `autorino_production`.`categories_articles` AS `CategoriesArticle` ON (`CategoriesArticle`.`article_id` IN (275, 276, 277, 274) AND `CategoriesArticle`.`category_id` = `Category`.`id`) | 4 | 4 | 0 | |
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`title`, `Tag`.`slug`, `Tag`.`occurrence`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `autorino_production`.`tags` AS `Tag` JOIN `autorino_production`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (275, 276, 277, 274) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Article' | 0 | 0 | 1 | maybe slow |
SELECT `Transport`.`id`, `Transport`.`title`, `Transport`.`lft`, `Transport`.`rght` FROM `autorino_production`.`transports` AS `Transport` WHERE `parent_id` = 1 ORDER BY `Transport`.`lft` asc | 12 | 12 | 0 | |
SELECT `Transport`.`id`, `Transport`.`title`, `Transport`.`lft`, `Transport`.`rght` FROM `autorino_production`.`transports` AS `Transport` WHERE `parent_id` = 0 ORDER BY `Transport`.`lft` asc | 12 | 12 | 0 | |
SELECT `State`.`id`, `State`.`title` FROM `autorino_production`.`states` AS `State` WHERE 1 = 1 | 25 | 25 | 0 | |