SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001665s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682335 LIMIT 1 [ RunTime:0.000655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682335 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477744,356599,840961,161401,957109,35169,524082,844531,267530,76500,800380,4079,345143,200613,388837,909929,442178,954679,924078,287437,603443,588343,810954,398888,615989,88722,47136,222279,393868,840582,55924,402334,4477,320983,101050,648704,514833,927444,141879,310602,880917,315068,767014,652371,370321,237224,284136,688902,422364,271750,681243,93834,565670,683484,660925,392644,718120,811750,10729,571183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]