SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517226 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517226 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589518,802062,365547,945275,427705,541408,79971,216688,887052,546395,884929,850410,477577,365586,725396,407065,775674,787519,1002725,485652,258471,516219,918780,1011992,906673,985085,230762,676652,953218,577090,33661,38958,578350,1028120,705534,648568,895774,336401,388659,656104,505133,974628,19783,202130,203156,222425,86000,505068,135827,119001,477981,237066,972274,805036,587991,68151,837418,1045300,217574,670509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]