SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491504 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491504 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79779,984236,533881,579275,935516,1030801,568142,333623,144105,156336,1034879,80313,694761,254060,1011536,685561,488095,10660,336371,22789,691940,41815,855790,631894,955249,823252,801147,218144,322643,313299,359076,11374,260884,589283,61068,989153,964365,491087,403105,90050,218543,790875,421393,737049,653538,435897,115234,853786,362639,711982,330607,892642,1028486,345222,244737,711892,359490,18879,543561,162966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]