SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810843 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810843 [ RunTime:0.001367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201642,118747,256896,787857,736034,514062,547447,76150,133936,519651,558792,615990,660054,179036,337202,965265,801703,513445,596704,889578,417439,555716,92666,1014024,724883,605791,441078,546354,414423,736205,318116,181803,848005,119605,760895,321342,264962,361432,347502,45491,819526,369594,3196,903013,873645,57769,1033697,610140,13553,443869,383289,88957,785167,164225,302075,347487,615618,825883,795969,100346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]