SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682830 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682830 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107454,65479,513211,904903,333030,830490,392024,304686,334477,758428,296044,814901,380834,609075,52022,923644,667206,773615,890867,350992,819434,169605,861094,358427,10352,298049,113206,929269,21306,724795,422808,106256,615760,22255,82993,634396,377330,115881,225846,98875,370502,322622,994448,858922,557768,118024,388525,925093,419980,326521,163767,719417,812855,190103,1032034,742290,919005,554056,424378,991547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]