SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817691 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817691 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046928,91327,819836,350959,680344,918560,122804,110193,529090,990475,405172,418787,1044984,373899,364748,732741,798954,254047,831329,58761,660080,429501,783578,946474,519021,94096,289518,615074,590075,304457,257669,1005936,995035,204496,287613,390794,512415,929579,147990,564847,868515,622253,498601,886581,132997,229977,207157,381843,416942,624109,486182,74196,195106,143267,1033084,202804,84213,691764,10703,579988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]