SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455939 LIMIT 1 [ RunTime:0.000936s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455939 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167038,197732,541950,607100,568095,773739,758179,620904,765111,862412,922099,632645,915211,484326,371107,454918,230223,954273,184249,717077,115169,1004917,691790,344728,268038,921679,667227,955158,825408,225210,410117,1025166,844826,64214,849922,417767,116464,111261,136680,481178,930576,732204,343818,130219,633657,141890,668094,338843,371306,671852,771329,256120,318008,633765,341243,16922,524575,120940,597844,350533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]