SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547448 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547448 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817,1035723,35690,162511,971306,525142,850142,685763,609337,640818,438488,302823,860948,65061,897795,384744,232022,297025,870325,349623,401882,1043471,164581,120270,453537,238808,283764,678526,92452,94671,373847,228373,296782,103163,956770,389928,762647,548593,614624,212692,257950,356589,422494,401240,666718,861093,87423,941077,654532,464808,891534,975230,985824,472417,78561,451186,253546,919544,331286,126698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]