SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193943 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193943 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422337,697079,1033328,321781,364057,350673,1003580,114249,511348,990669,845010,261126,306602,650216,297501,452372,840535,575956,168050,728355,71543,254148,304373,383367,694887,673711,215169,510461,574757,195456,451986,1019865,1012333,478303,801344,443186,632133,466876,646222,912448,49161,129725,480726,934067,295139,285214,923999,177258,723094,296692,847131,232398,71222,973334,924556,856061,8332,61753,1015307,861698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]