SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455205 LIMIT 1 [ RunTime:0.000979s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455205 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283501,229230,35572,728847,984412,534088,48145,349310,799425,803703,810820,328006,170445,862918,416623,591543,858333,731388,750190,664583,236804,3745,508959,449468,200769,23247,493953,522823,87461,669956,598268,821329,34392,28823,504581,395988,946862,143129,185332,937484,896229,356342,431615,706831,120748,873988,686192,929080,612383,197176,97535,851459,525798,520206,292410,345179,852982,33057,604980,404871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]