SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341688 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341688 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893489,133929,270838,647523,926975,428850,853083,1025961,781536,850885,391501,111394,504499,633963,265704,375890,79142,790533,814798,820241,961277,256922,542199,282436,990148,378078,1038108,1014235,201161,251595,327181,723428,938139,492238,747752,222780,155610,612677,469308,889026,705867,504343,679075,320492,996460,75835,930419,1008989,779019,790954,38110,403878,619637,794176,19077,343486,312000,122375,120015,48013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001143s ]