SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354150 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354150 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539226,222797,269681,510417,105310,69769,513491,326,661445,713461,154251,581862,310684,505510,434513,616551,987653,535087,635165,670836,107524,85509,634928,103164,553473,604881,834796,1021081,372746,489073,141305,974628,598119,95742,167209,796960,556475,311392,295150,625107,669675,979672,183969,560594,725316,551238,481026,892465,527169,134378,194934,473172,1007073,29971,217546,199004,197582,71682,868648,579152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]