SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96601 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96601 [ RunTime:0.004366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381914,957851,28740,75559,159642,494858,91450,404991,181211,899153,542233,475206,451225,916374,186358,973136,459560,240291,773574,235518,87861,755937,956162,498817,807918,290852,871530,298177,912420,30335,217818,769910,377917,503148,793774,799585,981175,988345,778689,187047,13474,833071,407529,113173,287762,694741,825182,889073,142336,799001,1010243,1006289,28118,159993,559901,966706,233394,955612,961684,38041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]