SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423471 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423471 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420298,750534,476975,1023979,133385,931227,79152,951436,912431,681527,804711,660033,23422,90528,113288,561992,857691,707428,458934,797736,379752,201421,555626,943546,295163,318241,568579,470142,95204,992337,364102,308548,861280,218556,529824,256525,177099,973932,55527,546114,755775,42669,559299,407623,971274,519488,673161,383158,53136,824397,70836,38448,75365,278681,983108,304029,585572,331741,879217,478091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001558s ]