SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330112 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330112 [ RunTime:0.003388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036610,959584,200006,761125,1044809,368564,587600,251767,90136,355722,472965,257086,990566,327540,933190,255373,659887,1010370,809921,764946,314596,600682,165465,120689,665742,854590,24637,422610,284279,215306,949456,1033577,284462,1018494,619346,469536,601681,413201,389949,831674,826351,588681,122944,36365,525135,242938,597686,784330,347223,438823,903551,74620,582318,600369,66534,655543,781856,849890,911636,354377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000877s ]