SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401321 LIMIT 1 [ RunTime:0.000910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401321 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693821,495054,844127,485821,702385,1020916,231498,841991,336425,579857,976130,475157,607783,393903,213501,1019329,914543,426499,852980,42419,569270,509634,553643,149200,107339,752136,911026,490893,535873,619930,504940,506198,50037,461480,409628,456637,748702,845743,954363,425045,706207,802399,627508,108792,207337,985567,649290,596580,723580,128900,467442,589727,451885,1011737,151831,804744,147779,948903,26307,93893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001486s ]