SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518927 LIMIT 1 [ RunTime:0.002597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518927 [ RunTime:0.006367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924061,808320,193830,1008219,832296,137844,404133,395167,812916,601401,383735,201394,57824,606481,804162,389498,581293,760806,635943,956502,1047340,478382,201912,596550,707955,428615,279766,503784,208086,489280,584139,489097,919547,570966,415075,973495,409382,211716,178859,1048771,409374,897669,174463,174263,152754,497603,695180,315359,467256,148663,598652,982958,215942,203437,690250,753134,822786,724021,953367,295212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]