SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524009 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524009 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681761,178167,352436,1032124,126977,129395,21259,152262,192826,883565,143312,37574,368005,201025,288692,261560,111954,567740,949122,200976,770511,30266,404630,388572,268366,112190,307913,1003848,458079,701139,744283,878551,975554,116787,919589,827989,561574,683711,621097,1007541,202164,882724,360750,256445,705778,422117,707127,920901,450115,334852,854872,452590,96864,609704,322506,847893,1043451,481522,394759,162060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]