SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452699 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452699 [ RunTime:0.003640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301502,105387,707410,693631,405371,1007202,45960,285093,759709,517294,916686,345860,380346,134273,155723,199262,955280,815939,306878,860634,504441,859163,473387,874847,836443,464623,694082,563922,274383,683042,749104,423574,979523,175382,435646,852160,582641,141096,75109,375849,843610,87275,118907,1063,330404,279099,230364,657891,185162,205935,407884,593614,959947,71153,219882,1020565,125125,91433,185388,359791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]