SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560923 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560923 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315430,186026,242188,320048,579925,403401,251653,22707,910918,570627,600144,894937,879351,382723,114220,590250,797510,339408,495715,1044314,516525,449051,335731,835780,842119,691567,647824,524860,628072,684688,836379,762112,1005890,583194,311999,336906,978556,165464,2652,918662,578891,830878,718313,658867,123904,125481,183491,77682,735114,605865,815551,111078,109267,163937,264120,882472,52480,1006811,448036,845754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]