SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495311 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495311 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633426,109583,701179,1023241,794219,641366,177020,284082,720729,354085,437128,381185,825153,144575,233250,27294,194401,499951,952947,560220,950850,537529,691079,781702,40911,474112,455497,12507,915027,562421,688520,531131,867025,413675,74113,469335,677854,88608,314329,384308,677483,979620,262214,551833,658076,864653,907895,717873,764447,634940,75834,556316,167597,370791,536875,422564,93096,70677,902115,449015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]