SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681969 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681969 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032786,774948,505259,221082,673700,393073,487654,465558,333221,233012,465243,105024,605928,792673,655153,239878,374804,161884,528439,660511,592561,536558,722458,366394,325089,643739,93625,662798,125296,685807,780072,560852,678829,650933,1034425,656500,981084,861576,325919,574723,421502,472912,470340,341654,1003872,58002,222423,888984,315491,175056,310366,364049,988056,25907,767939,915154,535352,599052,388338,879712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]