In long past lives the author of this little book had much to do with educational work, and he seems to have brought over with him an intense interest in education.
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003625s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000608s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000642s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.007402s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000746s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000396s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000718s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.004786s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.001423s ]
SELECT * FROM `ls_goods` WHERE `id` = 124143 AND `status` = 1 LIMIT 1 [ RunTime:0.001180s ]
UPDATE `ls_goods` SET `click_count` = 104 , `update_time` = 1788981903 WHERE `id` = 124143 [ RunTime:0.000777s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 124143 LIMIT 1 [ RunTime:0.000810s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 24 LIMIT 1 [ RunTime:0.003742s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.001004s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.001114s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.002738s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.005842s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000544s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000673s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.001209s ]
SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.001100s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 10 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000591s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000348s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 11 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001860s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 14 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001565s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1788981843 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.448879s ]