| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `OfficeRubric`.`id`, `OfficeRubric`.`slug`, `OfficeRubric`.`caption`, `OfficeRubric`.`email_to`, `OfficeRubric`.`position`, `OfficeRubric`.`disabled` FROM `technobox`.`office_rubrics` AS `OfficeRubric` WHERE `OfficeRubric`.`disabled` = '0' ORDER BY `OfficeRubric`.`position` DESC, `OfficeRubric`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Office`.`id`, `Office`.`office_rubric_id`, `Office`.`caption`, `Office`.`address`, `Office`.`map_zoom`, `Office`.`map_coord_n`, `Office`.`map_coord_e`, `Office`.`map_image`, `Office`.`contacts`, `Office`.`email`, `Office`.`working_hour`, `Office`.`position`, `Office`.`disabled` FROM `technobox`.`offices` AS `Office` WHERE `Office`.`office_rubric_id` = (1) ORDER BY `Office`.`position` DESC, `Office`.`id` DESC | 3 | 3 | 0 | |
| SELECT `Setting`.`items_perpage` FROM `technobox`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Item`.`id`, `Item`.`uuid`, `Item`.`vendor_id`, `Item`.`equipment_id`, `Item`.`type_id`, `Item`.`slug`, `Item`.`caption`, `Item`.`h1`, `Item`.`articul_vendor`, `Item`.`articul_tehnoflot`, `Item`.`articul_ego`, `Item`.`content`, `Item`.`units`, `Item`.`balance`, `Item`.`price`, `Item`.`image`, `Item`.`thumbnail`, `Item`.`slider`, `Item`.`thumb`, `Item`.`position`, `Item`.`disabled`, `Item`.`srvalue`, `Item`.`srcount`, `Item`.`modified`, `Item`.`created`, `Vendor`.`id`, `Vendor`.`code`, `Vendor`.`slug`, `Vendor`.`caption`, `Vendor`.`h1`, `Vendor`.`content`, `Vendor`.`ratio`, `Vendor`.`meta_h1`, `Vendor`.`meta_title`, `Vendor`.`meta_description`, `Vendor`.`meta_keywords`, `Vendor`.`image`, `Vendor`.`thumbnail`, `Vendor`.`disabled`, `Equipment`.`id`, `Equipment`.`equipment_rubric_id`, `Equipment`.`slug`, `Equipment`.`caption`, `Equipment`.`h1`, `Equipment`.`content`, `Equipment`.`meta_title`, `Equipment`.`meta_description`, `Equipment`.`meta_keywords`, `Equipment`.`image`, `Equipment`.`schema`, `Equipment`.`thumbnail`, `Equipment`.`position`, `Equipment`.`disabled`, `Type`.`id`, `Type`.`parent_id`, `Type`.`lft`, `Type`.`rght`, `Type`.`slug`, `Type`.`h1`, `Type`.`caption`, `Type`.`content`, `Type`.`meta_title`, `Type`.`meta_description`, `Type`.`meta_keywords`, `Type`.`image`, `Type`.`thumbnail`, `Type`.`position`, `Type`.`disabled` FROM `technobox`.`items` AS `Item` LEFT JOIN `technobox`.`vendors` AS `Vendor` ON (`Item`.`vendor_id` = `Vendor`.`id`) LEFT JOIN `technobox`.`equipments` AS `Equipment` ON (`Item`.`equipment_id` = `Equipment`.`id`) LEFT JOIN `technobox`.`types` AS `Type` ON (`Item`.`type_id` = `Type`.`id`) WHERE `Item`.`disabled` = '0' AND `Item`.`slug` = 'datchik-kontakta-dveri-165m-scc-liniya-scccm-61-10' ORDER BY `Item`.`caption` ASC, `Item`.`id` DESC LIMIT 1 | 1 | 1 | 12 | maybe slow |
| SELECT `AttachmentImage`.`id`, `AttachmentImage`.`model`, `AttachmentImage`.`foreign_key`, `AttachmentImage`.`caption`, `AttachmentImage`.`image`, `AttachmentImage`.`thumbnail`, `AttachmentImage`.`slider`, `AttachmentImage`.`thumb`, `AttachmentImage`.`position`, `AttachmentImage`.`disabled` FROM `technobox`.`attachment_images` AS `AttachmentImage` WHERE `model` = 'Item' AND `AttachmentImage`.`foreign_key` = (1605) | 0 | 0 | 0 | |
| SELECT `AttachmentFile`.`id`, `AttachmentFile`.`model`, `AttachmentFile`.`foreign_key`, `AttachmentFile`.`caption`, `AttachmentFile`.`file`, `AttachmentFile`.`position`, `AttachmentFile`.`disabled` FROM `technobox`.`attachment_files` AS `AttachmentFile` WHERE `model` = 'Item' AND `AttachmentFile`.`foreign_key` = (1605) | 0 | 0 | 0 | |
| SELECT `Equipment`.`id`, `Equipment`.`equipment_rubric_id`, `Equipment`.`slug`, `Equipment`.`caption`, `Equipment`.`h1`, `Equipment`.`content`, `Equipment`.`meta_title`, `Equipment`.`meta_description`, `Equipment`.`meta_keywords`, `Equipment`.`image`, `Equipment`.`schema`, `Equipment`.`thumbnail`, `Equipment`.`position`, `Equipment`.`disabled`, `EquipmentsItem`.`id`, `EquipmentsItem`.`equipment_id`, `EquipmentsItem`.`item_id` FROM `technobox`.`equipments` AS `Equipment` JOIN `technobox`.`equipments_items` AS `EquipmentsItem` ON (`EquipmentsItem`.`item_id` = 1605 AND `EquipmentsItem`.`equipment_id` = `Equipment`.`id`) | 9 | 9 | 1 | maybe slow |
| SELECT `LinkedItem`.`id`, `LinkedItem`.`uuid`, `LinkedItem`.`vendor_id`, `LinkedItem`.`equipment_id`, `LinkedItem`.`type_id`, `LinkedItem`.`slug`, `LinkedItem`.`caption`, `LinkedItem`.`h1`, `LinkedItem`.`articul_vendor`, `LinkedItem`.`articul_tehnoflot`, `LinkedItem`.`articul_ego`, `LinkedItem`.`content`, `LinkedItem`.`units`, `LinkedItem`.`balance`, `LinkedItem`.`price`, `LinkedItem`.`image`, `LinkedItem`.`thumbnail`, `LinkedItem`.`slider`, `LinkedItem`.`thumb`, `LinkedItem`.`position`, `LinkedItem`.`disabled`, `LinkedItem`.`srvalue`, `LinkedItem`.`srcount`, `LinkedItem`.`modified`, `LinkedItem`.`created`, `ItemsItem`.`id`, `ItemsItem`.`item_id`, `ItemsItem`.`linked_item_id` FROM `technobox`.`items` AS `LinkedItem` JOIN `technobox`.`items_items` AS `ItemsItem` ON (`ItemsItem`.`item_id` = 1605 AND `ItemsItem`.`linked_item_id` = `LinkedItem`.`id`) WHERE `LinkedItem`.`disabled` = '0' ORDER BY RAND() ASC LIMIT 4 | 0 | 0 | 0 | |
| SELECT `Store`.`id`, `Store`.`caption`, `Store`.`position`, `Store`.`disabled`, `ItemsStore`.`id`, `ItemsStore`.`item_id`, `ItemsStore`.`store_id`, `ItemsStore`.`q` FROM `technobox`.`stores` AS `Store` JOIN `technobox`.`items_stores` AS `ItemsStore` ON (`ItemsStore`.`item_id` = 1605 AND `ItemsStore`.`store_id` = `Store`.`id`) | 2 | 2 | 40 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `technobox`.`items` AS `Item` WHERE `Item`.`id` = 1605 | 1 | 1 | 0 | |
| SELECT `Item`.`id`, `Item`.`uuid`, `Item`.`vendor_id`, `Item`.`equipment_id`, `Item`.`type_id`, `Item`.`slug`, `Item`.`caption`, `Item`.`h1`, `Item`.`articul_vendor`, `Item`.`articul_tehnoflot`, `Item`.`articul_ego`, `Item`.`content`, `Item`.`units`, `Item`.`balance`, `Item`.`price`, `Item`.`image`, `Item`.`thumbnail`, `Item`.`slider`, `Item`.`thumb`, `Item`.`position`, `Item`.`disabled`, `Item`.`srvalue`, `Item`.`srcount`, `Item`.`modified`, `Item`.`created`, `Vendor`.`id`, `Vendor`.`code`, `Vendor`.`slug`, `Vendor`.`caption`, `Vendor`.`h1`, `Vendor`.`content`, `Vendor`.`ratio`, `Vendor`.`meta_h1`, `Vendor`.`meta_title`, `Vendor`.`meta_description`, `Vendor`.`meta_keywords`, `Vendor`.`image`, `Vendor`.`thumbnail`, `Vendor`.`disabled` FROM `technobox`.`items` AS `Item` LEFT JOIN `technobox`.`vendors` AS `Vendor` ON (`Item`.`vendor_id` = `Vendor`.`id`) WHERE `Item`.`disabled` = '0' AND `Item`.`id` = (1605) AND `Item`.`id` != 1605 ORDER BY FIELD(`Item`.`id`, 1605) ASC | 0 | 0 | 0 | |
| SELECT `Item`.`id`, `Item`.`uuid`, `Item`.`vendor_id`, `Item`.`equipment_id`, `Item`.`type_id`, `Item`.`slug`, `Item`.`caption`, `Item`.`h1`, `Item`.`articul_vendor`, `Item`.`articul_tehnoflot`, `Item`.`articul_ego`, `Item`.`content`, `Item`.`units`, `Item`.`balance`, `Item`.`price`, `Item`.`image`, `Item`.`thumbnail`, `Item`.`slider`, `Item`.`thumb`, `Item`.`position`, `Item`.`disabled`, `Item`.`srvalue`, `Item`.`srcount`, `Item`.`modified`, `Item`.`created`, `Vendor`.`id`, `Vendor`.`code`, `Vendor`.`slug`, `Vendor`.`caption`, `Vendor`.`h1`, `Vendor`.`content`, `Vendor`.`ratio`, `Vendor`.`meta_h1`, `Vendor`.`meta_title`, `Vendor`.`meta_description`, `Vendor`.`meta_keywords`, `Vendor`.`image`, `Vendor`.`thumbnail`, `Vendor`.`disabled` FROM `technobox`.`items` AS `Item` LEFT JOIN `technobox`.`vendors` AS `Vendor` ON (`Item`.`vendor_id` = `Vendor`.`id`) WHERE `Item`.`disabled` = '0' AND `Item`.`type_id` = 44 AND `Item`.`id` NOT IN (1605) ORDER BY RAND() ASC LIMIT 8 | 4 | 4 | 11 | maybe slow |
| SELECT `Type`.`lft`, `Type`.`rght` FROM `technobox`.`types` AS `Type` WHERE `Type`.`disabled` = '0' AND `Type`.`id` = 44 ORDER BY `Type`.`position` DESC, `Type`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Type`.`id`, `Type`.`slug`, `Type`.`caption` FROM `technobox`.`types` AS `Type` WHERE `Type`.`disabled` = '0' AND 1 = 1 AND `Type`.`lft` <= 41 AND `Type`.`rght` >= 42 ORDER BY `Type`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Vendor`.`id`, `Vendor`.`caption` FROM `technobox`.`vendors` AS `Vendor` WHERE `Vendor`.`disabled` = '0' ORDER BY `Vendor`.`caption` ASC, `Vendor`.`id` DESC | 56 | 56 | 1 | |
| SELECT `EquipmentRubric`.`slug`, `EquipmentRubric`.`caption`, `EquipmentRubric`.`id` FROM `technobox`.`equipment_rubrics` AS `EquipmentRubric` WHERE `EquipmentRubric`.`disabled` = '0' ORDER BY `EquipmentRubric`.`position` DESC, `EquipmentRubric`.`id` DESC | 24 | 24 | 0 | |
| SELECT `Equipment`.`id`, `Equipment`.`equipment_rubric_id`, `Equipment`.`slug`, `Equipment`.`caption`, `Equipment`.`h1`, `Equipment`.`content`, `Equipment`.`meta_title`, `Equipment`.`meta_description`, `Equipment`.`meta_keywords`, `Equipment`.`image`, `Equipment`.`schema`, `Equipment`.`thumbnail`, `Equipment`.`position`, `Equipment`.`disabled` FROM `technobox`.`equipments` AS `Equipment` WHERE `Equipment`.`equipment_rubric_id` IN (12, 30, 31, 32, 47, 49, 45, 46, 14, 33, 34, 35, 36, 37, 38, 39, 40, 43, 52, 50, 51, 16, 41, 42) ORDER BY `Equipment`.`position` DESC, `Equipment`.`id` DESC | 54 | 54 | 1 | |
| SELECT `Type`.`id`, `Type`.`slug`, `Type`.`caption`, `Type`.`parent_id` FROM `technobox`.`types` AS `Type` WHERE `Type`.`disabled` = '0' ORDER BY `Type`.`position` DESC, `Type`.`id` DESC | 135 | 135 | 1 | |
| SELECT `Page`.`id`, `Page`.`caption`, `Page`.`content`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`modified`, `Page`.`disabled` FROM `technobox`.`pages` AS `Page` WHERE `Page`.`disabled` = '0' AND `Page`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
