SHOW FULL COLUMNS FROM `ba_lang` [ RunTime:0.000488s ]
SELECT `code`,`name`,`icon`,`weigh` FROM `ba_lang` WHERE `status` = 1 ORDER BY `weigh` DESC [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `ba_web_product` [ RunTime:0.000493s ]
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` = '81' AND `p`.`status` = '1' AND `p`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000814s ]
SHOW FULL COLUMNS FROM `ba_web_classify_trans` [ RunTime:0.000555s ]
SELECT `name` FROM `ba_web_classify_trans` WHERE `classify_id` = 30 AND `lang` = 'zh-cn' LIMIT 1 [ RunTime:0.000307s ]
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.000368s ]
SELECT `id`,`title` FROM `ba_web_page` WHERE `identifier` = 'home' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000273s ]
SELECT * FROM `ba_web_page` WHERE `identifier` = 'common' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `ba_web_page_tpl` [ RunTime:0.000552s ]
SELECT * FROM `ba_web_page_tpl` WHERE `id` = 4 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `ba_web_page_items` [ RunTime:0.000537s ]
SELECT * FROM `ba_web_page_items` WHERE `page_id` = 2 AND `delete_time` IS NULL ORDER BY `id` ASC [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `ba_web_page_items_trans` [ RunTime:0.000502s ]
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.002271s ]
SHOW FULL COLUMNS FROM `ba_web_menu` [ RunTime:0.000575s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000460s ]
SHOW FULL COLUMNS FROM `ba_web_menu_trans` [ RunTime:0.000507s ]
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.000516s ]
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.000436s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000450s ]
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.000491s ]
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.000413s ]