SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175002 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175002 [ RunTime:0.006123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596342,141696,523872,633718,253816,66616,391785,615518,656472,898351,802349,482600,135998,247051,627630,197080,644377,52784,57018,735809,106682,285454,294740,950777,531653,680223,268351,293996,1046196,726663,74261,629749,59132,8293,470608,578872,649452,354250,729047,566810,193814,760709,191667,183209,48140,414076,567698,513619,198059,69497,116107,815744,188233,876396,998474,391144,879722,966089,138211,435543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]