SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43481 LIMIT 1 [ RunTime:0.003461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43481 [ RunTime:0.003053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666401,444922,337311,147234,943661,216812,669418,979047,378130,979802,592022,1031125,41462,384839,329297,666037,8410,416984,918616,180951,697822,957971,466549,390317,456909,69497,154265,417514,503374,599872,573684,589958,720519,556267,724989,360686,727287,18914,558425,227729,492980,31855,221452,585755,564988,84058,909445,80560,179961,806669,863959,744998,931330,605407,535458,772433,21889,987999,99948,525316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001065s ]