SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989083 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989083 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602221,589753,777401,812305,931703,935486,232938,519035,1036411,643800,699849,82315,944826,1016967,61383,811716,344902,684247,809893,943353,485123,288156,258798,585247,164778,1043324,103687,607560,952700,445827,913294,827360,67505,775801,978358,821997,561152,786334,14543,304171,436156,988867,236821,342277,846548,362151,1034731,620225,140196,708155,759944,43514,904250,346640,705732,863339,687203,637171,272508,675533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]