SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043816 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043816 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473631,188146,285567,267582,741222,81344,640420,250352,343997,406038,1007362,997657,884425,744843,48284,432142,38157,900801,756011,522745,1029980,527360,1043604,716609,401910,75715,504756,460233,8587,465010,372386,568518,741623,557312,983568,120906,1010064,926918,674557,657629,903191,642694,328895,116762,567631,3733,787084,528440,267693,83230,471878,267337,74474,890415,360185,605195,599691,599867,126529,403634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]