Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `automatik_aros` | | 7 | 7 | 20 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `automatik_acos` | | 7 | 7 | 21 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_aros_acos` | | 7 | 7 | 9 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_products` | | 39 | 39 | 12 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `automatik_attachment_groups` | | 9 | 9 | 10 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_packages` | | 6 | 6 | 7 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_packages_products` | | 5 | 5 | 8 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_categories` | | 20 | 20 | 9 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_videos` | | 5 | 5 | 10 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_subcategories` | | 7 | 7 | 12 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_products_categories` | | 7 | 7 | 10 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_attachments` | | 12 | 12 | 20 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_settings` | | 8 | 8 | 19 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_specials` | | 4 | 4 | 22 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_orders` | | 28 | 28 | 18 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_order_items` | | 16 | 16 | 21 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_users` | | 27 | 27 | 5 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_groups` | | 5 | 5 | 5 | |
SHOW FULL COLUMNS FROM `automatik_delivery_methods` | | 14 | 14 | 10 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_offers` | | 38 | 38 | 14 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_offer_items` | | 15 | 15 | 5 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_cart_progress` | | 6 | 6 | 6 | |
SHOW FULL COLUMNS FROM `automatik_products_products` | | 5 | 5 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_event_log` | | 7 | 7 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `automatik_bookmarks` | | 7 | 7 | 3 | maybe slow |
SELECT `Settings`.`id`, `Settings`.`parameter`, `Settings`.`value`, `Settings`.`description`, `Settings`.`inputtype`, `Settings`.`group`, `Settings`.`superadmin`, `Settings`.`install` FROM `automatik_settings` AS `Settings` WHERE 1 = 1 | | 57 | 57 | 5 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`tree` = '0' ORDER BY `Category`.`lft` asc | | 15 | 15 | 6 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`active` = ('1') AND `Category`.`parent_id` IS NULL ORDER BY `Category`.`lft` ASC | | 14 | 14 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_categories` AS `Category` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`category_id` = `Category`.`id`) WHERE `Category`.`id` = 57 LIMIT 1 | | 1 | 1 | 4 | maybe slow |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`category_id` = 57 | | 0 | 0 | 3 | maybe slow |
SELECT `Video`.`id`, `Video`.`name`, `Video`.`ident`, `Video`.`product_id`, `Video`.`category_id` FROM `automatik_videos` AS `Video` WHERE `Video`.`category_id` = (57) | | 0 | 0 | 3 | maybe slow |
SELECT `Special`.`id`, `Special`.`product_id`, `Special`.`category_id`, `Special`.`special_index`, `Product`.`id`, `Product`.`name`, `Product`.`desc`, `Product`.`number`, `Product`.`price`, `Product`.`discount_code`, `Product`.`name_custom`, `Product`.`number_long`, `Product`.`desc_imported`, `Product`.`supplier_number`, `Product`.`tax`, `Product`.`active`, `Product`.`stock`, `Product`.`group`, `Product`.`price_discount`, `Product`.`created`, `Product`.`updated`, `Product`.`weight`, `Product`.`name_custom_eng`, `Product`.`name_custom_swe`, `Product`.`desc_eng`, `Product`.`desc_swe`, `Product`.`show_price`, `Product`.`seo_product_title`, `Product`.`seo_product_link`, `Product`.`seo_product_meta_desc`, `Product`.`seo_product_meta_keywords`, `Product`.`name_custom_short`, `Product`.`name_custom_short_eng`, `Product`.`name_custom_short_swe`, `Product`.`image_text`, `Product`.`group_product`, `Product`.`price_custom`, `Product`.`delivery_time`, `Product`.`delivery_time_nostock`, `Product`.`delivery_time_eng`, `Product`.`delivery_time_nostock_eng`, `Product`.`delivery_time_swe`, `Product`.`delivery_time_nostock_swe` FROM `automatik_specials` AS `Special` LEFT JOIN `automatik_products` AS `Product` ON (`Special`.`product_id` = `Product`.`id`) WHERE `Special`.`category_id` = '57' AND NOT (`Special`.`special_index` IS NULL) ORDER BY `Special`.`category_id` ASC, `Special`.`special_index` ASC | | 0 | 0 | 5 | maybe slow |
SELECT `Package`.`id`, `Package`.`name`, `Package`.`desc`, `Package`.`index`, `Package`.`category_id`, `Package`.`slug`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_packages` AS `Package` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`package_id` = `Package`.`id`) WHERE `Package`.`category_id` = 57 ORDER BY `Package`.`category_id` ASC, `Package`.`index` ASC | | 0 | 0 | 14 | maybe slow |
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 57 LIMIT 1 | | 1 | 1 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 17 AND `Category`.`rght` >= 18 ORDER BY `Category`.`lft` asc | | 1 | 1 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_categories` AS `Category` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` = 57 AND `Category`.`active` = '1' | | 0 | 0 | 3 | maybe slow |
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 57 LIMIT 1 | | 1 | 1 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 17 AND `Category`.`rght` >= 18 ORDER BY `Category`.`lft` asc | | 1 | 1 | 4 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 57 ORDER BY `Category`.`lft` asc | | 0 | 0 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 57 ORDER BY `Category`.`lft` asc | | 0 | 0 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`active` = ('1') AND `Category`.`parent_id` IS NULL ORDER BY `Category`.`lft` ASC | | 14 | 14 | 1 | maybe slow |
SELECT `ProductsCategory`.`id`, `ProductsCategory`.`product_id`, `ProductsCategory`.`category_id`, `ProductsCategory`.`subcategory_id`, `ProductsCategory`.`desc`, `ProductsCategory`.`created`, `ProductsCategory`.`imported` FROM `automatik_products_categories` AS `ProductsCategory` WHERE `category_id` = 57 AND `subcategory_id` IS NULL | | 6 | 6 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `automatik_products` AS `Product` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`product_id` = `Product`.`id`) WHERE `Product`.`id` IN (4527, 4892, 4896, 4895, 4971, 4994) AND `Product`.`active` = 1 AND NOT (((`Product`.`price` = 0) AND (`Product`.`price_custom` = 0) AND (`Product`.`price_discount` = 0) AND (NOT (`Product`.`group_product` = 1)))) | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `automatik_suppliers` | | 4 | 4 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`desc`, `Product`.`number`, `Product`.`price`, `Product`.`discount_code`, `Product`.`name_custom`, `Product`.`number_long`, `Product`.`desc_imported`, `Product`.`supplier_number`, `Product`.`tax`, `Product`.`active`, `Product`.`stock`, `Product`.`group`, `Product`.`price_discount`, `Product`.`created`, `Product`.`updated`, `Product`.`weight`, `Product`.`name_custom_eng`, `Product`.`name_custom_swe`, `Product`.`desc_eng`, `Product`.`desc_swe`, `Product`.`show_price`, `Product`.`seo_product_title`, `Product`.`seo_product_link`, `Product`.`seo_product_meta_desc`, `Product`.`seo_product_meta_keywords`, `Product`.`name_custom_short`, `Product`.`name_custom_short_eng`, `Product`.`name_custom_short_swe`, `Product`.`image_text`, `Product`.`group_product`, `Product`.`price_custom`, `Product`.`delivery_time`, `Product`.`delivery_time_nostock`, `Product`.`delivery_time_eng`, `Product`.`delivery_time_nostock_eng`, `Product`.`delivery_time_swe`, `Product`.`delivery_time_nostock_swe`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_products` AS `Product` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`product_id` = `Product`.`id`) WHERE `Product`.`id` IN (4527, 4892, 4896, 4895, 4971, 4994) AND `Product`.`active` = 1 AND NOT (((`Product`.`price` = 0) AND (`Product`.`price_custom` = 0) AND (`Product`.`price_discount` = 0) AND (NOT (`Product`.`group_product` = 1)))) LIMIT 20 | | 6 | 6 | 1 | maybe slow |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4895 | | 1 | 1 | 1 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (7) | | 1 | 1 | 6 | maybe slow |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4896 | | 1 | 1 | 1 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (8) | | 1 | 1 | 1 | |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4994 | | 1 | 1 | 1 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (9) | | 1 | 1 | 1 | |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4527 | | 1 | 1 | 1 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (23) | | 1 | 1 | 1 | |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4892 | | 1 | 1 | 1 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (24) | | 1 | 1 | 1 | |
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 4971 | | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (25) | | 1 | 1 | 1 | |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '121' LIMIT 1 | | 0 | 0 | 3 | maybe slow |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '121' LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '278' LIMIT 1 | | 0 | 0 | 0 | |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '271' LIMIT 1 | | 0 | 0 | 0 | |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '271' LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '121' LIMIT 1 | | 0 | 0 | 1 | maybe slow |
SELECT `ProductsProduct`.`id`, `ProductsProduct`.`product_id`, `ProductsProduct`.`linked_product_id`, `ProductsProduct`.`mode`, `ProductsProduct`.`created` FROM `automatik_products_products` AS `ProductsProduct` WHERE `ProductsProduct`.`mode` = 3 AND `ProductsProduct`.`product_id` IN (4527, 4892, 4896, 4895, 4971, 4994) | | 0 | 0 | 1 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`parameter`, `Setting`.`value`, `Setting`.`description`, `Setting`.`inputtype`, `Setting`.`group`, `Setting`.`superadmin`, `Setting`.`install` FROM `automatik_settings` AS `Setting` WHERE `Setting`.`parameter` = 'cms_root' LIMIT 1 | | 1 | 1 | 1 | |
SELECT `Setting`.`id`, `Setting`.`parameter`, `Setting`.`value`, `Setting`.`description`, `Setting`.`inputtype`, `Setting`.`group`, `Setting`.`superadmin`, `Setting`.`install` FROM `automatik_settings` AS `Setting` WHERE `Setting`.`parameter` = 'cms_pretty_urls' LIMIT 1 | | 1 | 1 | 0 | |