SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109002 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109002 [ RunTime:0.002892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406388,170683,518283,774095,495443,172742,611411,712688,291119,269958,1028685,629173,81282,337513,761392,850814,498206,824965,689753,320789,1029452,781499,919989,501136,821262,229605,1007965,689007,334146,380021,857614,743722,101843,59623,1032929,1003973,337136,1048400,621387,751463,1037870,18157,66060,799527,123578,178158,482475,250433,335772,580143,429927,375780,1047638,217967,172791,523806,859224,61618,527408,209539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]