SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451713 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451713 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019021,798433,158938,968037,794620,41140,766872,79116,663725,744276,730982,99889,533952,620374,872474,204135,283169,28722,299703,78291,954909,887534,765818,349913,433267,168656,431113,1014683,878368,36838,371504,560935,1480,296201,413919,142148,864421,132672,483739,795953,210093,180301,805814,349877,746001,382472,601221,369796,282191,223287,226951,346018,399133,168506,866609,284548,649831,463546,772138,611625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]