SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416719 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416719 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469803,371083,613179,289733,736304,37066,22651,853979,906298,847632,349327,655457,202877,702180,624965,412631,211010,26235,22871,216394,201294,890792,987250,536831,588220,910072,201659,484254,673751,523756,896201,297862,453546,860519,751153,422653,1002590,636894,523834,494627,994316,692404,579947,1019271,216233,652326,1036487,1044238,557615,278395,94694,505489,436626,539395,111647,762141,1020749,197585,316424,1036075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]