SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254201 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254201 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440330,617928,66574,399202,280570,322953,823022,513343,44279,1020511,432737,614179,73289,898895,955593,52730,1025132,813442,594328,315004,489160,516336,498520,838010,166776,968607,685750,209365,634098,18707,236795,260528,365722,953286,1024251,507103,345677,217979,1041692,439224,753105,395645,71764,410144,498907,1017135,100151,820006,945732,884283,367664,30842,18289,20772,896906,474674,421550,656457,27925,1041659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]