SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416993 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416993 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754857,962659,413122,1017590,265340,1046184,262413,940726,441288,924907,890516,303869,149164,502641,605105,567525,478436,123957,512608,752005,835753,374775,159799,598619,550089,255042,806991,1033533,469108,220680,1019417,929487,995960,627008,58436,551974,1040254,789458,72880,968965,54889,626989,267929,640202,945362,757548,645050,411884,1029989,817898,644500,1011903,398529,971829,981561,903288,222332,800170,530146,727255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]