SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198107 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198107 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752510,687613,473401,839158,958418,495985,406148,648863,546093,1037703,367805,241070,248823,284552,999039,122007,744443,450569,978179,664107,40021,996030,14546,391313,607275,1029613,248036,702904,447114,773733,764203,997131,832883,542431,15475,1183,293188,909107,1020899,256900,56262,435139,1032619,935123,218086,862883,219834,100028,454820,591016,869336,971847,49250,924015,297227,960513,672710,985495,990577,609183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]