SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402381 LIMIT 1 [ RunTime:0.000594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402381 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394369,296114,550465,374957,1019437,825342,501751,93455,671544,486984,886971,1006894,668919,952111,998188,333191,106243,125520,922337,150519,937101,159358,378576,339128,735591,692524,981240,584204,114650,255898,77668,536074,1008095,991671,825746,596002,427336,965109,338994,709009,347623,938394,1017054,260725,901981,639763,57936,514546,682211,442815,1016241,376203,427439,1021471,118455,331256,899085,560920,757155,368022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]