SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339197 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339197 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414942,406672,460071,802504,947511,233264,594828,228972,552482,577789,905637,22998,648853,290260,784271,521747,759128,88209,615391,419927,755081,145342,448096,845247,107233,373300,652243,573888,321861,253325,692936,782937,547953,208557,95996,17594,341273,678103,839209,829290,970351,1000180,777735,393012,651301,316918,236351,579975,586652,327560,239109,357910,1013726,243907,457307,306351,599993,735341,318198,643965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]