SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534471 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534471 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544663,368085,585300,634368,364146,123556,964969,173572,704876,353444,64312,4332,128432,842863,840199,558321,28713,482075,359387,767235,581806,244050,381151,134951,880388,880084,568825,88887,723096,679463,191260,823977,805064,540050,415741,453910,546755,877097,805208,176615,5438,89982,345518,196346,560701,577925,1021903,383020,745708,918758,997438,688232,712983,819248,105376,376324,90451,791506,130403,264611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]