magento后台登录所做的sql查询

SET SQL_MODE=''

SET NAMES utf8

SHOW TABLE STATUS LIKE 'core_resource'

SELECT `core_resource`.* FROM `core_resource`

SELECT `index_process`.`indexer_code` FROM `index_process`

SELECT `core_website`.`website_id`, `core_website`.`code`, `core_website`.`name` FROM `core_website`

SELECT `core_store`.`store_id`, `core_store`.`code`, `core_store`.`name`, `core_store`.`website_id` FROM `core_store` ORDER BY `sort_order` ASC

SELECT `core_config_data`.`scope`, `core_config_data`.`scope_id`, `core_config_data`.`path`, `core_config_data`.`value` FROM `core_config_data`

SELECT `main_table`.* FROM `core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC

SELECT `main_table`.* FROM `core_website` AS `main_table` ORDER BY main_table.sort_order ASC, main_table.name ASC

SELECT `main_table`.* FROM `core_store_group` AS `main_table` ORDER BY main_table.name ASC

SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN ('admin/index/index/key/c4379781ff51e6325eafff764a16add2/', 'admin/index/index/key/c4379781ff51e6325eafff764a16add2')) AND (store_id IN(0, 0))

SELECT `core_translate`.`string`, `core_translate`.`translate` FROM `core_translate` WHERE (store_id IN (0 , '0')) AND (locale = 'en_US') ORDER BY `store_id` ASC


//后台业务逻辑开始
SELECT `admin_user`.* FROM `admin_user` WHERE (username='liujianghua')

SELECT `admin_role`.* FROM `admin_role` WHERE (parent_id > '0') AND (user_id = '10')

UPDATE `admin_user` SET `logdate` = '2014-11-26 03:19:59', `lognum` = '2' WHERE (user_id = 10)

SELECT `admin_role`.* FROM `admin_role` ORDER BY `tree_level` ASC

SELECT `r`.*, `a`.`assert_type`, `a`.`assert_data` FROM `admin_rule` AS `r`\x0a LEFT JOIN `admin_assert` AS `a` ON a.assert_id = r.assert_id

DELETE FROM `captcha_log` WHERE (type = 2) AND (value = 'liujianghua')

DELETE FROM `captcha_log` WHERE (type = 1) AND (value = '127.0.0.1')



下面好像又重复了，从头开始执行到core_translate表，应该是跳转一个页面
SELECT `admin_user`.* FROM `admin_user` WHERE (`admin_user`.`user_id`='10')

SELECT `core_flag`.* FROM `core_flag` WHERE (`core_flag`.`flag_code`='synchronize')

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`\x0a INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, '0')) AND (link.area = 'adminhtml') AND (link.package = 'default') AND (link.theme = 'oneplus2014') AND (layout_update.handle = 'default') ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`\x0a INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, '0')) AND (link.area = 'adminhtml') AND (link.package = 'default') AND (link.theme = 'oneplus2014') AND (layout_update.handle = 'STORE_admin') ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`\x0a INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, '0')) AND (link.area = 'adminhtml') AND (link.package = 'default') AND (link.theme = 'oneplus2014') AND (layout_update.handle = 'THEME_adminhtml_default_oneplus2014') ORDER BY `layout_update`.`sort_order` ASC

SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`\x0a INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, '0')) AND (link.area = 'adminhtml') AND (link.package = 'default') AND (link.theme = 'oneplus2014') AND (layout_update.handle = 'adminhtml_dashboard_index') ORDER BY `layout_update`.`sort_order` ASC

SELECT `adminnotification_inbox`.* FROM `adminnotification_inbox` WHERE (is_read != 1) AND (is_remove != 1) ORDER BY `notification_id` DESC LIMIT 1

SELECT SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * IFNULL(main_table.base_to_global_rate, 0)) AS `revenue`, SUM((IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_tax_refunded, 0)) * IFNULL(main_table.base_to_global_rate, 0)) AS `tax`, SUM((IFNULL(main_table.base_shipping_invoiced, 0) - IFNULL(main_table.base_shipping_refunded, 0)) * IFNULL(main_table.base_to_global_rate, 0)) AS `shipping`, COUNT(main_table.entity_id) AS `quantity` FROM `sales_flat_order` AS `main_table` WHERE (created_at >= '2014-11-25 04:20:04' AND created_at <= '2014-11-26 04:20:04') AND (main_table.state NOT IN ('pending_payment', 'new'))

SELECT SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * main_table.base_to_global_rate) AS `lifetime`, AVG((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * main_table.base_to_global_rate) AS `average` FROM `sales_flat_order` AS `main_table` WHERE (main_table.status NOT IN('canceled')) AND (main_table.state NOT IN('new', 'pending_payment'))

SELECT SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0) - IFNULL(main_table.base_shipping_invoiced, 0) - (IFNULL(main_table.base_total_refunded, 0) - IFNULL(main_table.base_tax_refunded, 0) - IFNULL(main_table.base_shipping_refunded, 0))) * IFNULL(main_table.base_to_global_rate, 0)) AS `revenue`, COUNT(main_table.entity_id) AS `quantity`, CONCAT(DATE_FORMAT(DATE_ADD(`created_at`, INTERVAL 0 SECOND), '%Y-%m-%d %H:'), '00') AS `range` FROM `sales_flat_order` AS `main_table` WHERE (main_table.state NOT IN ('pending_payment', 'new')) AND (created_at >= '2014-11-25 04:20:04' AND created_at <= '2014-11-26 04:20:04') GROUP BY CONCAT(DATE_FORMAT(DATE_ADD(`created_at`, INTERVAL 0 SECOND), '%Y-%m-%d %H:'), '00') ORDER BY `range` ASC

SELECT COUNT(*) FROM (SELECT MAX(DATE_FORMAT(period, '%Y-%m-%d')) AS `period`, SUM(qty_ordered) AS `qty_ordered`, `sales_bestsellers_aggregated_yearly`.`product_id`, MAX(product_name) AS `product_name`, MAX(product_price) AS `product_price` FROM `sales_bestsellers_aggregated_yearly` WHERE (EXISTS (SELECT 1 FROM `catalog_product_entity` AS `existed_products` WHERE (sales_bestsellers_aggregated_yearly.product_id = existed_products.entity_id))) AND (store_id IN(0)) GROUP BY `product_id` LIMIT 5) AS `t`

SELECT MAX(DATE_FORMAT(period, '%Y-%m-%d')) AS `period`, SUM(qty_ordered) AS `qty_ordered`, `sales_bestsellers_aggregated_yearly`.`product_id`, MAX(product_name) AS `product_name`, MAX(product_price) AS `product_price` FROM `sales_bestsellers_aggregated_yearly` WHERE (EXISTS (SELECT 1 FROM `catalog_product_entity` AS `existed_products` WHERE (sales_bestsellers_aggregated_yearly.product_id = existed_products.entity_id))) AND (store_id IN(0)) GROUP BY `product_id` ORDER BY `qty_ordered` DESC LIMIT 5

SELECT `main_table`.* FROM `core_config_data` AS `main_table` WHERE (value LIKE '{{base_url}}')

SELECT `core_flag`.* FROM `core_flag` WHERE (`core_flag`.`flag_code`='admin_notification_survey')

SELECT `adminnotification_inbox`.`severity`, COUNT(notification_id) AS `count_notice` FROM `adminnotification_inbox` WHERE (is_remove=0) AND (is_read=0) GROUP BY `severity`

SELECT `main_table`.*, IF(e.events IS NULL, 0, e.events) AS `events` FROM `index_process` AS `main_table`\x0a LEFT JOIN (SELECT `index_process_event`.`process_id`, COUNT(*) AS `events` FROM `index_process_event` WHERE (status='new') GROUP BY `process_id`) AS `e` ON e.process_id=main_table.process_id

SELECT COUNT(DISTINCT main_table.entity_id) FROM `sales_flat_order` AS `main_table`

SELECT `main_table`.*, `main_table`.`total_item_count` AS `items_count`, CONCAT_WS(' ', main_table.customer_firstname, main_table.customer_lastname) AS `customer`, (main_table.base_grand_total * main_table.base_to_global_rate) AS `revenue` FROM `sales_flat_order` AS `main_table` ORDER BY created_at DESC LIMIT 5

SELECT COUNT(*) FROM `catalogsearch_query` AS `main_table`

SELECT `main_table`.* FROM `catalogsearch_query` AS `main_table` ORDER BY updated_at DESC LIMIT 5

SELECT DISTINCT COUNT(*) FROM `catalogsearch_query` AS `main_table`

SELECT DISTINCT IF(synonym_for IS NOT NULL AND synonym_for != '', synonym_for, query_text) AS `name`, `main_table`.`num_results`, `main_table`.`popularity` FROM `catalogsearch_query` AS `main_table` ORDER BY `popularity` desc, `name` ASC LIMIT 5