SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028096 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028096 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503370,515098,488850,52100,959401,809971,723337,882409,430859,554185,1035133,604696,331848,765107,552959,742582,514254,694949,944702,21826,802818,390375,504638,872808,485651,604287,594792,425778,621855,721017,40900,446095,1022368,618864,786316,134902,217002,735126,961881,602254,565864,438513,808543,768791,499466,708249,808756,183124,910463,65233,173216,940016,271295,157900,112145,760990,466725,106510,968174,724448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]