SHOW FULL COLUMNS FROM `ba_web_page` [ RunTime:0.000426s ]
SELECT `identifier` FROM `ba_web_page` WHERE `delete_time` IS NULL [ RunTime:0.000169s ]
SELECT 1 [ RunTime:0.000121s ]
SHOW FULL COLUMNS FROM `ba_config` [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `ba_lang` [ RunTime:0.000353s ]
SELECT `code`,`name`,`icon`,`weigh` FROM `ba_lang` WHERE `status` = 1 ORDER BY `weigh` DESC [ RunTime:0.000197s ]
SHOW FULL COLUMNS FROM `ba_web_product` [ RunTime:0.000313s ]
SELECT `p`.`id`,`p`.`cover`,`p`.`images`,`p`.`classify_id`,`pt`.`name`,`pt`.`description`,`pt`.`specs`,pz.name AS name_zh,pz.description AS description_zh,pz.specs AS specs_zh FROM `ba_web_product` `p` LEFT JOIN `ba_web_product_trans` `pt` ON `pt`.`product_id`=p.id AND pt.lang = 'zh-cn' LEFT JOIN `ba_web_product_trans` `pz` ON `pz`.`product_id`=p.id AND pz.lang = 'zh-cn' WHERE `p`.`id` = '65' AND `p`.`status` = '1' AND `p`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `ba_web_classify_trans` [ RunTime:0.000265s ]
SELECT `name` FROM `ba_web_classify_trans` WHERE `classify_id` = 27 AND `lang` = 'zh-cn' LIMIT 1 [ RunTime:0.000175s ]
SELECT `p`.`id`,`p`.`identifier`,`p`.`title` FROM `ba_web_page` `p` INNER JOIN `ba_web_page_tpl` `t` ON `t`.`id`=`p`.`page_tpl_id` WHERE `t`.`identifier` = 'products' AND `t`.`delete_time` IS NULL AND `p`.`delete_time` IS NULL ORDER BY `p`.`id` ASC LIMIT 1 [ RunTime:0.000197s ]
SELECT `id`,`title` FROM `ba_web_page` WHERE `identifier` = 'home' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000150s ]
SELECT * FROM `ba_web_page` WHERE `identifier` = 'common' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000143s ]
SHOW FULL COLUMNS FROM `ba_web_page_tpl` [ RunTime:0.000294s ]
SELECT * FROM `ba_web_page_tpl` WHERE `id` = 4 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `ba_web_page_items` [ RunTime:0.000264s ]
SELECT * FROM `ba_web_page_items` WHERE `page_id` = 2 AND `delete_time` IS NULL ORDER BY `id` ASC [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `ba_web_page_items_trans` [ RunTime:0.000276s ]
SELECT * FROM `ba_web_page_items_trans` WHERE `page_items_id` IN (58,59,60,62,63,65,66,67,68,73,74,75,76,77,78,79,80,82,83,84,85,86,87,300,302) AND `lang` = 'zh-cn' [ RunTime:0.001209s ]
SHOW FULL COLUMNS FROM `ba_web_menu` [ RunTime:0.000315s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `ba_web_menu_trans` [ RunTime:0.000271s ]
SELECT `name`,`menu_id` FROM `ba_web_menu_trans` WHERE `menu_id` IN (47,46,45,21,44,30,43,31,7,42,32,20,1,41,33,29,2,40,34,28,3,39,35,27,4,38,36,26,5,37,25,8,6,24,23,22) AND `lang` = 'zh-cn' [ RunTime:0.000282s ]
SELECT `identifier`,`id` FROM `ba_web_page` WHERE `id` IN (46,45,44,15,43,29,42,30,3,41,31,8,1,40,32,23,39,33,24,38,34,25,37,35,26,36,27,4,21,18,17,16) [ RunTime:0.000208s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000253s ]
SELECT `name`,`menu_id` FROM `ba_web_menu_trans` WHERE `menu_id` IN (47,46,45,21,44,30,43,31,7,42,32,20,1,41,33,29,2,40,34,28,3,39,35,27,4,38,36,26,5,37,25,8,6,24,23,22) AND `lang` = 'zh-cn' [ RunTime:0.000261s ]
SELECT `identifier`,`id` FROM `ba_web_page` WHERE `id` IN (46,45,44,15,43,29,42,30,3,41,31,8,1,40,32,23,39,33,24,38,34,25,37,35,26,36,27,4,21,18,17,16) [ RunTime:0.000249s ]