SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305888 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305888 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387698,940319,1035805,558131,138783,890365,135194,837612,968442,814381,776203,491090,478823,641703,303391,390884,973226,112343,662050,1021583,447366,708483,840661,155548,28774,474309,47998,782461,994187,417335,478760,598858,329372,627763,328991,286662,551673,489796,1011070,582480,1001412,918092,607005,19032,704036,250687,423313,653340,786434,330740,542210,770952,956164,21463,720435,328714,920993,976483,824749,479318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]