SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540829 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540829 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160040,306638,414216,74234,672279,75189,30530,14754,10908,575557,912411,400969,39616,738241,854786,561547,178818,76243,914398,604021,432712,852408,887737,857742,963898,671649,415592,412262,495056,249869,661485,624436,689070,794323,572634,350307,406279,587083,131500,135452,914557,845438,340586,413858,358086,723367,310790,917134,60861,608147,5231,369349,301974,973864,254147,397623,438365,925961,1009833,309491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001778s ]