SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40535 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40535 [ RunTime:0.003201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671317,143412,113572,383256,694123,878460,220704,666725,132213,146498,904955,884293,320123,898824,68451,480297,842103,410426,334883,702,666362,821530,895053,46334,205830,251377,192433,313201,206846,460016,999659,975294,343558,67983,11262,1041860,231761,329296,947241,647688,556292,207428,528125,5237,47451,327052,375562,806664,583255,762334,453879,623390,553541,14616,947506,876807,722113,985947,772493,292079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]