SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800448 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800448 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038013,181733,738568,618833,851335,28966,816990,824891,172588,240421,23976,696726,161495,809923,73223,854581,34360,795487,1038310,43541,49080,701836,928769,875876,505654,121789,241097,516707,52250,826164,515701,500555,427784,581672,1033309,50645,358192,611137,543159,928936,30432,45784,401180,892922,864188,808308,356412,1000861,785017,101703,847639,166119,159317,228970,1030432,158654,356144,229768,994070,985102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]